I've been switched over to the new Google Apps Script IDE. I used to be able to click FILE > PROJECT PROPERTIES to access global properties for files I cann
When I run a script (UPDATE_PRODUCT_DATA) through the editor it runs fine. When it is run through a Trigger it fails. It is failing at getFilesByName – b
In google apps script, with onEdit trigger, how do I get the old values of all the cells if the edited range has multiple cells? In the Event object documentati
I have multiple sheets with different dates and different calendar ids. The intention is to have the script go over each sheet and import it in the calendar wit
=== Answer added in code === please could you help me resolve this : How get form.test[j] work in the Apps Script code of the form submit.Input name are : test1
EDIT*** Modified the question now that I have a proper source... I am trying to copy a communication log to Google Sheets and don't know enough about scripting
After some searching I found this code to get a sidebar of all tabs (workbooks) in Google Sheets as a hyperlink. I am looking to add two functionalities to this
In Google Sheets, is there a way to calculate the width, in pixels, of a piece of text given a font and a font size? Excel has a PixelWidth function, but I didn
I have made two Google spreadsheets. One is parent sheet and another is a child sheet that imports data from parent sheet. This data is imported using a standal
I am trying to figure out the official code sample of Google: /** * The event handler triggered when the selection changes in the spreadsheet. * @param {Event
I was using the below google app script to delete emails automatically from my trash folder. for some reason, this is no longer deleting the emails however the
I have a google spreadsheet addon, Formula Tracer Sidebar, published on the Google workspace marketplace. Every once in a while, the following error entry is in
I'm using this script I found and it's working fine in inserting a new row, I just add a new line to clear the row clearContent(). I wanted to modify this so th
I have the following trigger setTrigger() set for when a Google Form is submitted. For testing purposes I created a simple function triggerFunction() that creat
I am trying to develop a navigational menu being referenced to different pages in my app. am using Materialize css as a ui and placed the nav codes in a separat
I am needing to copy all data in a row (including formulas and formatting) to another tab (when a checkbox is ticked), and then I want to clear the contents of
I am needing to copy all data in a row (including formulas and formatting) to another tab (when a checkbox is ticked), and then I want to clear the contents of
I am trying to run the code of this post, : Google Script: Play Sound when a specific cell change the Value with the recommendation of Rob Blakemore Could some
How do I get page number, which is modified (deleting/adding content) in Google doc, Google Slide in last modification time? I have used Google drive revision
I have mild general programming knowledge but know basically nothing about google apps scripts specifically. I am trying to create dynamic page breaks in googl