Google Apps Script (GAS) is a JavaScript cloud scripting language that lets you extend Google Apps and build web applications.

learn more… | top users | synonyms (1)

1
vote
0answers
17 views

dropdown script https://drive.google.com/open?id=1623xEoNJABNoqBhT4MhynWpiSsVBjuLylt5rPW9af1o [duplicate]

I have a script to populate a dropdown list based on a selection of another cell's dropdown list. E.g., if user does not make a choice from D9 dropdown menu, therefore F9 dropdown is Blank but has ...
2
votes
1answer
113 views

Google Form with an alert

I created a registration form with Google Forms. Now I would like to have an alert displayed before the submitter starts filling out data. This is my code: function onOpen() { FormApp.getUi() ...
2
votes
1answer
206 views

Dropdown list based on the result of another cell's dropdown

I want to populate a dropdown list based on a selection of another cell's dropdown list. Here is my spreadsheet. E.g., if user does not make a choice from D20 dropdown menu, therefore F20 dropdown is ...
2
votes
0answers
113 views

Google URL shortener rate limit exceeded on first request

I'm using the Google URL shortener service in Apps scripts to shorten very long Google Docs links when sending automated emails to our team. While building the script I ended up using 315 requests out ...
2
votes
0answers
54 views

Run two timestamps for time in/out in one Google Sheets [closed]

I have this code: function function1(event) { var timezone = "GMT-8"; var timestamp_format = "hh:mm:ss a"; var updateColName = "Agent"; var timeStampColName = "Start Time"; var sheet = ...
3
votes
1answer
73 views

Google Script Active Cell Validation

A Google Script I am writing that seems to be failing. The first part of this script is to validate that only a specific sheet is being changed. In this case column 3 of my sheet called Labor.by....
2
votes
1answer
49 views

How can specific columns of a Google spreadsheet be exported as CSV?

I have a Google spreadsheet with 10 columns of data. I would like to export columns A, C, E, F as csv. I do not need to export the entire spreadsheet. Can this be done? I do not mind using Google ...
1
vote
1answer
416 views

Is there a way to generate edit response url for google form

I have a Google Form With a Google spreadsheet to store responses. In my spread sheet I have 4 column: name, email, revenue, and a fourth column Id which is used to identify the particular recipient. ...
2
votes
1answer
63 views

Auto calculate and display timestamp in a specific row and column

I have a spreadsheet with a formula that works to display the timestamp in the same row, but is there a way to set a column at the same time so I don't have multiple time stamps displaying along that ...
3
votes
1answer
209 views

Send selected cells from a row via email

I am starting with Google Scripts and I was hoping to create a sheet that could email selected cells from a row. What I want to do by selecting Send Email at the end of a row it then selects pre ...
1
vote
1answer
89 views

“sort” function results in all of my data going to the bottom of the sheet

I am trying to use a form to create a list of jobs for our student employees, which exists as an editable Google sheet. I would like to be able to have any staff member add jobs that need to be taken,...
3
votes
0answers
59 views

Create button “Add” to add a new row in sheets [duplicate]

I'd like to know how to add a new row copying all formulas from previous row .. What I'm looking for is as follows SR. NO ITEM CODE DESCRIPTION UNIT COST 1 5463345 (...
3
votes
1answer
235 views

Hide/Show Multiple Groups of Columns in Google Sheets

I found a script (on this post: I need to hide/show a group of columns in Google Sheets in a simple way ) that adds a dropdown menu with two options: Show Range X of Columns & Hide Range X of ...
1
vote
1answer
66 views

Change a working function from onOpen() to onEdit()

I currently have a working function that uses the onOpen() trigger to run. I am needing to make this an on edit instead of onOpen function so that a when a change is made in my master sheet, the child ...
2
votes
1answer
72 views

Rearranging Google form data in a new sheet

I am trying to use a form to create a list of jobs for our student employees, which exists as an editable Google sheet. The thought, being any of the staff could add jobs that need to be taken, by ...
2
votes
1answer
73 views

How do I get multiple driving times in Google sheets without “Service invoked error”?

I keep getting this error. "Service invoked too many times for one day: route. (line 3)." Here is the link to my sample sheet. With script attached https://docs.google.com/spreadsheets/d/...
4
votes
1answer
51 views

Update column with last update of row in Google Sheets… except the header

I've been using this code to find the most recent update of a given row: function onEdit() { var s = SpreadsheetApp.getActiveSheet(); var r = s.getActiveCell(); if( r.getColumn() != 5 ) { //...
1
vote
1answer
222 views

How to copy related row data from Google Sheets remote tab or Sheet into current Sheet with a script?

I could use importRange, but I want to actually place the values themselves into the cells, instead. For sheets with many rows, a lot of importRange formulas can cause lag and slow down performance. ...
2
votes
1answer
43 views

Filtering a range by another range, custom function just says “internal error”

I'm trying to filter a range by comparing it to another range. I couldn't figure out a way to do this with functions in Google Spreadsheets so I made my own. function FilterByArray(range, filterRange)...
2
votes
2answers
92 views

How to retrieve the HTML content of a Google Sites footer with a Google Apps Script?

I cannot find in documentation an equivalent to getSummary() or getTitle() to retrieve the HTML content of a Google Sites footer (the custom footer editable through Edit site layout > Custom Footer)...
3
votes
1answer
98 views

How to auto-update function based on background color

I've been referencing @w0lf's answer to help me calculate the sum of cells based on their background color in Google Sheets. From the comments and some other research it appears that changing the ...
1
vote
1answer
74 views

Utilizing noreply option on Google Script SendEmail function

I have a script that takes data from an existing data table and sends it out to a distro list. A quick snippet of the code I'm using is: var emailDelivery = templateSheet.getRange("C2").getValue(); ...
1
vote
1answer
19 views

Use the order of sheets in which they appear in a Google spreadsheet

Goal What I would like to accomplish is to have my aggregation-master-schedule-sheet (see context) put schedules in the same order that the sheets are. I.e. the left most sheet is 1st, the 2nd ...
1
vote
1answer
30 views

Send the argument of a custom function as an email

I am trying to send email via script in Google Spreadsheet. I know that the argument in this case cell B4 will be integer. In my cell is function =sendEmails(B4) and my script looks like this. ...
2
votes
1answer
582 views

E-Mail from Google Spreadsheets: including image for signature takes out formatting of message

Following situation: Sending emails from google spreadsheets. I have a compiled text (with line breaks), which is stored in var message. I have been trying to include a picture for the signature. To ...
2
votes
1answer
86 views

“getAs()” error - send an Email with Attachment using GoogleAppScript [duplicate]

I am very new to GoogleAppsScript and struggling. Here is my problem: Trying to send multiple E-Mails via Spreadsheet. Want to attach a PDF to those mails. Getting the following error: TypeError: ...
5
votes
1answer
54 views

error making a copy of google app script

I'm trying to duplicate a Google app script file in Google drive that I own, but it gives me this error Limit Exceeded: Create. This is when I'm in the file and I use File --> Make a copy... When I ...
1
vote
1answer
235 views

Sorting alphabetically (A-Z) ignoring beginning “A”, “An” and “The” using a script

I have a Movie list using Google Sheets that I would like do some sorting with using a script rather than a formula. Column A is the movie Title. I would like to be able to sort the movie titles ...
-1
votes
1answer
241 views

Google Sheet: How to Sort Names in Column Alphabetically Ignoring “The”, “An” & “A”… and then pull names (skipping duplicates) into another tab [closed]

I have searched here and all over the web. I've found ways very close to some of what I want but can't really get close what i'm looking for. Especially as complexly as I want it. I apologize if I ...
2
votes
1answer
271 views

Google Scripts UI show new row as confirmation after form submit

I have tried several things, but decided to finally ask for help with this. I am using a Google Scripts UI form like the one found with the example to insert new rows into a Sheet. After the submit ...
2
votes
1answer
483 views

Multiple auto-populated select boxes Google Sheets Script UI

I found an example of how to auto-populate a drop-down select box from a Google Sheets range, for a Google Apps Script UI that enters new rows in the spreadsheet. I have so far been unable to figure ...
1
vote
1answer
728 views

Reference a Google Spreadsheet Row containing specific Text within Google App Script for spreadsheets

I am having trouble finding a function that can reference a row (the number of that row) containing specific text as criteria. I thought that VLookUp would work, but it's not really. Ideally it's ...
1
vote
1answer
143 views

Google Sheets Customize View Using Create Custom Menu and Hiding/Showing Specifc Columns

Trying to determine a way that I can use a custom menu (.createMenu) with views that will allow me to show / hide specific columns. I need the capability to pick specific multiple columns and not ...
0
votes
1answer
96 views

Google Sheets How to Hide or Show Specific Columns using Custom Menu [duplicate]

I've figured out how to create a custom menu, but I'd like to be able to hide or show certain columns (not necessarily ranges), based on what menu item is selected. Not sure on the next steps / can't ...
3
votes
1answer
93 views

What can break the relationship between the onFormSubmit function and a spreadsheet that is attached to a google form?

I had a working Google form, Google spreadsheet, and GAS script which would be called when the form was submitted. It worked fine until the did (one?) of the following things: Cleared out the ...
2
votes
0answers
28 views

How to put a Unicode Checkmark in your Google document and export it into a pdf using a script?

I have a need to put a checkbox, checked and unchecked in my script generated Google Docs document. What would I write in the AppScript to place this in my Google Docs document?
-1
votes
1answer
330 views

Need Help With a Script to Automatically Insert Rows in a Sheet Based on Other Rows/ Data Inserted in Another Sheet

I have a sheet titled 'Raw_Data' that I insert data into every day by inserting new rows above the data from the last day. I have another sheet titled 'Overall_Formulas' that populates formulas based ...
2
votes
1answer
43 views

Best way to iterate through all input arguments?

I am writing a custom function in sheets that will not have a defined number or format of arguments. As an example, the call might be: =myFunc(a1:b3,a2:a4,b1:b9,c1,d2, [might be more, might be less]) ...
1
vote
1answer
35 views

Get unique rows and their count in Spreadsheet

I have a sheet as below, | A | B | C | ------------- |abc|123|Yes| |jkl|123|No | |abc|123|Yes| |abc|567|Yes| I want to get the output like, | A | B | C |Count| ------------------- |abc|123|Yes| 2 ...
1
vote
0answers
86 views

Google Spreadsheets Loading Bug

A few days ago, I created a Google Spreadsheet and from what I remember, it was working fine. When I came back to it today, I saw that a few cells said Loading... despite all cells in the column have ...
1
vote
1answer
499 views

Send email If one cell is greater than or equal to another

For some reason this script is not working and I was wondering if someone may guide me on fixing this? In my Google Spreadsheets, I just want the value in cell A2 to send an email if it's greater ...
1
vote
0answers
349 views

Google sheets query returns “loading…”

I've put together a web application that relies on a series of Google components. Google Forms collects data from users Google sheets saves the data (automatically) Additional "calculated" columns ...
2
votes
0answers
21 views

Toggle named range window with a button?

I would like to know if it would be possible to toggle the different features in sheets with a script. What I am trying to do is to basically create a button that will show the Named Ranges side ...
2
votes
1answer
112 views

How do I use a negative DURATION formatted cell from Google Spreadsheets in Google Scripts?

I'm using Google Spreadsheets and I have a sheet in the following format: Start | End | Partial result | Expected | Total 08:00 | 12:00 | 04:00 | 05:00 | -01:00 14:00 | 18:00 | 04:...
1
vote
0answers
39 views

Sudden issue when updating a Google Sheets Addon

I have a published Google Sheets addon, only for private use (visibility=private). I have made several version updates before, but yesterday, when I tried to make a new update from script editor, I ...
2
votes
1answer
207 views

Fixing permission problems in cross-spreadsheet import when using Apps Script

I created a function in the Apps Script associated with a spreadsheet: function importNotes() { s = SpreadsheetApp.openById('spreadsheet-key').getRange('F2').getNotes(); return s; } ...
3
votes
2answers
4k views

Create a popup in Google Spreadsheet

How can I create a popup in Google Sheets using script editor? I'd like to show a popup with a personalised notification. It should start like this: function onOpen() { var ss = SpreadsheetApp....
1
vote
0answers
110 views

Is there a script to stamp & password protect a PDF on Google Drive?

I have a few PDFs on a Google Drive, I would like to watermark/stamp & password protect (to disallow editing) before I share them. Is there a solution using Google App Scripts?
2
votes
2answers
51 views

Prevent “invoked too many times per second” error in Google Apps script

I need a number to be converted to a name. In B1:B1000 I have numbers. In C1:C1000 I has function name. On writing C30 got an error: invoked too many times per second ... how do I do function on range ...
2
votes
2answers
51 views

Sum all expenses of a given type given a list of expense types in a separate sheet

I use Google Sheets to keep track of my expenses. The file currently consists of: Sheet 1: "Expense Types" Sheet 2: "2015 Details". The first column of Sheet 1 contains the list of admissible ...