Use for questions about Google Apps Script, Google's JavaScript-based cloud scripting platform for automating tasks across Google products and third-party services.
I'm trying to get the following formula to work: function setDataValid(range, sourceRange) { var rule = SpreadsheetApp.newDataValidation().requireValueInRange(sourceRange, true).…
google-apps-script google-sheetsI am adding a unique ID to each submission of the form. Right now, I made that ID the first …
google-apps-script google-sheets google-formsI know that Google Apps Script has a getSheetId() method for the Sheet Class, but is there any way to …
google-apps-script google-sheetsI know this looks simple. In a Google spreadsheet, I have a column where I enter time in one timezone (…
google-apps-script google-sheets timezone dst formulasOn a shared Google spreadsheet: I don't want a specific user in my domain to view columns with sensitive data, …
google-apps-script google-sheetsI have an index/match formula that matches a specific file based on the date value of certain cells. Here's …
google-apps-script google-sheets google-sheets-formulaI am working on this script bound to a Google Sheets spreadsheet where I have this function running from a …
google-apps-script google-sheetsI'm trying to write a script that will take data from a Google spreadsheet and create events in my Google …
google-apps-script google-sheets google-calendar-apiRecently, I've been conducting a survey. I began creating it in Excel Forms Online but switched to Google Forms after …
google-apps-script google-sheets google-forms editingI am pulling data from a web service and it is formatted as JSON. I am writing a Google Apps …
json google-apps-script google-sheets