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 want to input a variable in a cell only if the cell is empty. The if statement, however, does …
google-apps-script google-sheets cell spreadsheetI would like to (programmatically) convert a text file with questions to a Google form. I want to specify the …
google-apps-script google-formsI need to convert a Google Spreadsheet column index into its corresponding letter value, for example, given a spreadsheet: I …
javascript google-apps-script indexing google-sheetsIs it possible to number the headings in a Google Docs/Drive document?
google-apps-script google-docs google-drive-apiI have a range of cells selected in a Google Sheets (activerange). I want to iterate over every cell in …
google-apps-script google-sheetsMy google app script is iterating through the user's google drive files and copying and sometimes moving files to other …
google-apps-scriptWhat would be the best way to compare two dates? var int = e.parameter.intlistbox; var startDate = rSheet.getRange(parseInt(…
date datetime google-apps-script date-manipulationI have created an google script which go to my mail and fetch attachments and put it into a folder (…
gmail google-apps-script email-attachments google-drive-apiHow do I add a formula like: =SUM(A1:A17) to a range of fields using the Google Apps Script …
google-apps-script google-sheets google-docsI have a sheet with a column of unix epoch times (in seconds): 1500598288 How can I convert these into normal …
javascript datetime google-apps-script google-sheets epoch