Category "google-apps-script"

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

Google apps script URL changes and does not open

I have an issue where other uses of my Google apps script's url is getting changed. Due to this issue they are not able to open the html page. Original url "htt

Modify a Google Slides presentation while presenting?

I'm afraid I already know the answer, but maybe someone else has found a way to do this. I've been perusing the Slide Apps Script reference, and I'm excited a

How do I use LockService properly every time in Google Apps Script?

I am trying to avoid concurrent process with LockService on my project. In test runs, LockService works for me without any problems. But when I roll my projec

Put a CSV file in a specific Sheet by Name

With this script I would to put the CSV in a specific Sheet named "TEST". I have tried with getSheetByName but without result. How could I proceed? function imp

Google Sheets appendRow with formula values

My goal is to write a script in Google Sheets that will copy two (or more) values from specific cells on a single row on a worksheet to the bottom of the list o

Can't deploy new version of published Google apps script app with Rest API

When trying to use https://developers.google.com/apps-script/api/reference/rest/v1/projects.deployments/update to update an existing deployment with a new versi

How do I connect to the Admanager API with Javascript? [closed]

I would like to connect to the Admanager and bring my reports but I have not been successful. An example of how to do it would be helpful.