Category "google-apps-script"

unexpected error DEADLINE_EXCEEDED google spreadsheet onOpen() trigger

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

Run Script to add new row via selected value in drop down and clear selected range in that selected row

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

Google Apps Script trigger function runs twice

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

how can i add inline javascripts to navigation template in Google App Scripts

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

Copy row contents to another sheet and clear data except formulas

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

Copy row contents to another sheet and clear data except formulas

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

Play Sound when a specific cell change the Value google sheets

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

Get last modified page

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

Dynamic Page Breaks in Google Sheets

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

Email trigger AutoHotKeys to run?

I am learning to use AutoHotKeys and I have a repetitive task that happens on every email. But it involves a different program outside of google. So I am wonder

Setting cells in google sheets as read-only without locking its column width?

Protecting a range in google sheet also locks the cell's column width. I would like to make a cell read-only but still allow the user to resize the column widt

Onclick Event Google Visualization Pie Chart create with Dynamic input value

I have 3 inputs and from where by click in a button get those input value and create a Google Visualization dynamic Pie Chart depend on those value . I have mad

Web Gmail shows message as starred even after Apps Script unstars it

OK, I think web Gmail is being screwy. I run a Google apps script that in part adds my "To-do" label to any thread I manually star, then archives and unstars it

Appending or inserting footnotes programmatically into google doc using google app script

I am using Google App Script to generate a new google doc. The contents of the document come from an array that is looped and paragraph elements are added, or t

Best Method for polling a google sheet for changes using a Google Apps Script Web App?

I am working on a google apps script web app to get it to poll a google sheet for changes/updates. At the moment this can either be "content" or simply when the

Try...catch not working as expected in Google Apps Script

[Edited to include a minimal reproducible example as suggested by T.J. Crowder.] I'm working on a simple function using Google Apps Script that is supposed to

Rebuilding e.namedValues in Index Order, Pushing to Document in Google Apps Script

I have a Google Form that has many different branches; as a result, out of ~100 questions in total, any given response only includes about 20 answers. I'm tryin

How to perform Cartesian Join with Google Scripts & Google Sheets?

I have found code for a basic 2 column Cartesian join but I have a slightly different situation. There are 3 Variables/Columns: Color, Color ID, & Item. I'd

Automatically Move Google Form Response by Ticking Check Box

I have 2 google Forms. User fills either of the google forms and it populates 2 "active" tabs within the same sheet to record user responses. I would like to us

Sharing different files to different emails

I want to sharE each file (by file id) in A column with the email in B column as (Editor). Example: I want to share file in A2 with the email in B2 and share sh