Questions tagged [google-apps-script-triggers]

Filter by
Sorted by
Tagged with
0
votes
1answer
115 views

Continuation token: Generate file listing of a google folder into a google sheet

I have a folder on Google with 18k files and need to list some variables from them into Google sheet. A solution for this was found on Insert image from Google Drive into Google Sheets However, ...
1
vote
2answers
962 views

Jump to today's date when opened

I have found a similar question here: How to make Google Sheet jump to today's column when opened? I want to do a similar thing, but I have the dates in row 5 not in the column. I tried several ...
2
votes
1answer
9k views

Script to copy values only

I have a script which copies new form data from one sheet to another. However, I only want the values and not the formatting to paste. Here is the script: function onFormSubmit() { // moves a ...
1
vote
1answer
15 views

Setting a trigger to send mail when data is added to a row that was empty

I`ve got an external app that sometimes adds data to the last row of a sheet, is there a way to trigger this to send a mail with the content of that row?
1
vote
1answer
14k views

Cell last modified date & user stamp Google Sheets?

I want the cells of two columns in my Spreadsheet to auto-update with the date (m/d/y) and name of user when cells in a certain range are edited. For instance, Catherine goes to sheet on 3/6/2017 (...
0
votes
2answers
264 views

How to Clear Cell(s) based on the Value of another Cell

I am looking for a script that will clear cell(s) when the value of another cell changes or is equal to ("X"). In the attachment I would like when Column "G" gets checked marked (TRUE), then ...
0
votes
0answers
10 views

Created an OnFormSubmit trigger but still getting error

I'm trying to create a script that will populate a Google Sheet template based on a Google Form--basically, following this verbatim . My code looks like this: function onFormSubmit(e) { //open the ...
0
votes
1answer
3k views

Show/Hide Rows based on text in a cell

I'm trying to toggle which rows are shown/hidden on multiple sheets in my Google Sheets document. Simply put, a user will provide an input on Sheet1, which will populate a "show" or "hide" value in ...
6
votes
5answers
23k views

How can I make some data Autosort in a spreadsheet on edit?

I am working with a simple spreadsheet that has name/lastnames in it. I need for the spreadsheet to automatically sort the entry alphabetically by the last name (column B). I have used the following ...
1
vote
2answers
2k views

Move cursor to cell in all sheets

I have the following script: function setActiveCells() { var wb = SpreadsheetApp.getActiveSpreadsheet(); var ws_names = wb.getRangeByName('an_sheets').getValues(); var ws_cells = wb....
0
votes
1answer
182 views

Help needed with script that auto-updates cells in column in Google Spreadsheet showing last modify date

I'm looking for some help with a script for a spreadsheet. I found a script (see below) that does half the trick for me, but I encounter two difficulties. What I am trying to accomplish is the ...
0
votes
1answer
20 views

How to open a specific tab based on today's date (Google Sheets)

I've made a 'Google Sheets' with 31 tabs for the dates of the month (1-31) How do I write a script that makes the spreadsheet open to that days tab? e.g. open tab 25 if today is Aug 25th I imagine (...
0
votes
1answer
35 views

How can I make some data on a Google Sheets auto-sorting but in different columns in every sheet?

If i want to sort different columns in every sheet, what do i have to change? function onEdit(event){ var sheet = SpreadsheetApp.getActiveSpreadsheet(); var editedCell = sheet.getActiveCell(); ...
0
votes
1answer
56 views

Script sometimes it works sometimes it dosent

I have 2 columns to enter Lat and Long coordinates in ( E and F ), those also contain the Formulas (for all rows, I just happened to choose row 768below) =IFERROR("N"&left(index(Split(D768,"N"),1)...
1
vote
2answers
732 views

Google App Script - changeType “REMOVE_GRID”

I'm using a Google spreadsheet. I'm attempting to create an onChange trigger that will activate a script when any sheet is added or deleted. I was able to get the script to work when a new sheet is ...
0
votes
1answer
35 views

Script Execution succeeds but reports failure

I'm running this script on a Google Form responses sheet: function autoSort(sheet) { var SORT_COLUMN_INDEX = 10; var ASCENDING = true; var NUMBER_OF_HEADER_ROWS = 1; var range = sheet....
0
votes
1answer
945 views

Google Script to set the current month once a day only in a cell

Currently, I'm using (Month(NOW()) to set the current month number in cell $D$1 of a spreadsheet. I know Month and Now are volatile functions and they're making the over sheet update way too slowly, ...
0
votes
2answers
543 views

inputBox in onEdit does not work for users

I have a strange problem... Simple function like: function onEdit() { var ss = SpreadsheetApp.getActiveSpreadsheet() var sheet = ss.getActiveSheet() var ui = SpreadsheetApp.getUi() var response = ...
0
votes
1answer
37 views

How to run a different script on multiple Google Sheet tabs?

The code writes an auto email once a trigger is met in the sheet. There are 3 different tabs pulled from the main sheet and each tab should run the script but with a different message for each tab. ...
0
votes
1answer
1k views

How to automatically set date in a cell when a different cell value is changed by a formula from data on another sheet?

I currently have a column, e.g. ColB, containing SUMIF functions with its data range from other sheets and a column, e.g. ColC, with dates that I want to automatically update to the last date ColB's ...
1
vote
1answer
961 views

Auto hide row based on cell text (formula based)

My plan is to hide an entire row if a specific cell in the row showed specific value. I already found the script and the script work amazing. But the problem now, since the script use onEdit function, ...
1
vote
3answers
4k views

How to execute a trigger only when one of the sheets is changed

When I have multiple sheets in a spreadsheet, I want to execute a trigger only when One of the Sheets is changed, not the others. OnChange() or OnEdit() is executing the trigger for any data change. ...
0
votes
1answer
18 views

postEdit functions getting range

Does anyone know how I can change the below function to postEdit rather than onEdit? I am trying to set this in an autoSort function so that the sheet will be edited only after all values in an ...
1
vote
1answer
34 views

How to open sheets to a specific tab based on days of the week?

I have a file with 7 tabs or sheets each of them represent a day of the week (Monday to Sunday). In each day (Tab) a have this formula in B2 to show the day of the week if it is today... =IF(WEEKDAY(...
1
vote
1answer
454 views

Run a Script When Tab Programmatically added to a Google Spreadsheet

I'm trying to pull data from an Adwords report to a Google Sheet through an Adwords script. This will be done on a daily basis. Every time the Adwords script runs, a new tab is created (and an old one ...
0
votes
1answer
16 views

Get exactly data to put on email message?

I got a function to email notice like this code below: function approvedby() { var approvedrange = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Responses 1").getRange("E2:E500"); var ...
0
votes
1answer
101 views

Can automatic send emails when checkbox = True?

I'm looking for an script can automatic send emails when checkbox is True. This is my format example: What i want is when im clicking on checkbox = True at F2, i can recieve an email with excactly ...
1
vote
1answer
17 views

The script(onSubmmit Trigger) only works in the script editor and doesn't work when the form is actually submitted

This is a follow up of How to send email to a person selected from a dropdown menuwith all answers of a response of the form submission? I want to notify mentors if they're selected by a user on a ...
0
votes
1answer
47 views

How to send email to a person selected from a dropdown menuwith all answers of a response of the form submission?

I want to notify mentors if they're selected by a user on a Google Form. The names of the mentors are in a drop-down menu in the Google Form. This is the form: https://forms.gle/iNuA5nB2J9koKhXt6. I'...
1
vote
1answer
2k views

Copy and paste information once a day form a Google spreadsheet

I have a Google spreadsheet that is being modified during the day, and need to copy and paste the final information (at 8 pm) in a different tab, each day, pasting the new information under the old ...
0
votes
0answers
180 views

What's causing this error when running Google sheets script?

Exception: The parameters (String,String,String,(class)) don't match the method signature for CalendarApp.Calendar.createEvent. (line 31, file "Copy of Code") 29 if (eventID != complete){ 30 ...
0
votes
0answers
24 views

Color cell background automatically if value has changed from original

Is it possible to automatically color cell backgrounds if their values has been changed (in my case, the only time a cell changes value is by manual user edit/input - no cell values are computed of ...
1
vote
1answer
87 views

How can I get to the bottom of a Google Sheet

I want to open my Google Sheets and go automatically to the bottom/last line entered as there are over 2000 lines. I have entered the below text in: tools > script editor, as seen in another post ...
0
votes
1answer
26 views

Prevent a Google Script from Modifying Date

I have a Google Sheet that I am applying an onEdit script to. That script (borrowed from WebApps:Convert all text to UPPERCASE in a Google Spreadsheet) capitalizes all new entries in every field of ...
0
votes
0answers
25 views

script correction for in the sheet

function onEdit() { var ss=SpreadsheetApp.getActiveSpreadsheet(); var s=ss.getActiveSheet(); if(s.getName()==="Sheet1") { var r=s.getActiveCell(); var v= r.getValue(); var s1 = ...
1
vote
0answers
33 views

Can I add a unique autoincrement field to multiple answers in a column in a Google Spreadsheet based on a Google Form?

I need to add a unique autoincrement field to multiple answers in a column in a Google Spreadsheet based on a Google Form. I was able to add the function trigger in scripts but I need to add the ...
20
votes
7answers
68k views

Can I add an autoincrement field to a Google Spreadsheet based on a Google Form?

Is it possible in Google Forms to give a unique value to each row it inserts into the spreadsheet as well as the timestamp?
3
votes
2answers
2k views

onEdit only updates top row after pasting (editing) multiple rows

I'm using a Google Spreadsheets and have a script that updates the "last email" column with a date stamp when an employee enters an email address into the prior column. The problem occurs when my ...
3
votes
2answers
1k views

Individual time stamps for individual sheets in a Google Spreadsheet containing multiple sheets

I am using the New Google Sheets, and I have created a "Master Document" that contains a multitude of sheets, with each expressing different kinds of data. I want a "Last modified" time stamp to ...
1
vote
1answer
4k views

Running multiple onEdit scripts

I am trying to run all three of these in any order but only the third runs: 1. function onEdit(){ var sh = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); var editedCell = sh....
0
votes
1answer
168 views

Google Sheets onEdit - Run Two Scripts

I'm trying to run two scripts in one sheet - Only the last one runs though - I'm sure I'm missing something small but any ideas? function onEdit(e) { moveRowsFromSheetToSheet_(e); ...
-1
votes
1answer
160 views

Cut and paste data from a row of cells from one tab to another tab in Google Sheets and repeat with new data

The below code works for Q3 but not for Q5. I'm relatively new to sheets and writing code and I'm sure that you can't have two functions with the same name but am unsure how to resolve so that I can ...
0
votes
0answers
163 views

Script trigger to Google Sheet that will work in Android mobile app

Would someone please help me script a trigger to start a macro in Google Sheets running on android 7.0. As Probaton asked in 2015 I have a similar problem. My macro works great in Google sheets on my ...
0
votes
1answer
28 views

Can't get If Else statement to run based on value of edited drop-down selection in Google Sheets Script

I have a dropdown field on a sheet (consisting of Wheat, Wood, Stone, etc.). When that dropdown field is edited, I want it to run one of a few similar functions, based on the dropdown selection (when ...
0
votes
1answer
500 views

TypeError: Cannot read property 'range' of undefined at onformsubmit(Code:10:17)

I am getting this error when running :TypeError: Cannot read property 'range' of undefined at onformsubmit(Code:10:17) I have installed the onformsubmit trigger but it is not working. What is not ...
1
vote
1answer
1k views

TypeError: Cannot read property 'range' of undefined at onformsubmit again after creating an event object

This is what I have written in Script editor so as to auto-apply a formula to a new added row when a new response is submitted on the Google Forms linked to my spreadsheet. First I was using ...
0
votes
1answer
31 views

Google form adding more than one row every time

I know that when a new response is submitted on Google form, a new row is auto-added to the linked spreadsheet. I use several onformsubmit triggers for my form and linked spreadsheet. But I do not ...
19
votes
1answer
31k views

Add a script trigger to Google Sheet that will work in Android mobile app

I have a Google sheet that includes a script that should be run when clicking a button. The recommended way to do this (as far as I can tell) is to insert an image and then attach a script to the ...
0
votes
1answer
243 views

Why don't work function onEdit(e) when using Zapier [duplicate]

I created a chatbot that using Zapier (through Webhook and JSON) for sending to my Google Sheet a name and a phone of user and Apps Script must generate a coupon code automatically. I used function ...
1
vote
1answer
2k views

Why would I be getting the error: Too many simultaneous invocations: Spreadsheets on a simple once a day trigger?

I've searched around and still can't find anything directly related to the failure message I'm receiving. The script hasn't changed and it used to run just fine, but now in the past week or so it's ...