Category "google-apps-script"

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

Enable Google API OAuth Scope

For one of the application created using Google Apps Script, some scopes are automatically added as follows in my app: https://www.googleapis.com/auth/drive

How do you create a "reverse pivot" in Google Sheets?

I am trying to produce a "reverse pivot" function. I have searched long and hard for such a function, but cannot find one that is already out there. I have a su

How to Publish/Deploy Google Sheet script as API executable programmatically?

I have a google sheet containing script, I want to perform following operations programmatically. Make this Google spreadsheet public programmatically. I want

document.getElementById "not defined" in Google Apps Script [duplicate]

I am currently working on a Google forms addon. The addon has a sidebar with an input field and a button. The ID of the input field is "emaili