Questions tagged [google-apps-script-triggers]
The google-apps-script-triggers tag has no usage guidance.
127
questions
-1
votes
1
answer
2k
views
Google Script to set the current month once a day only in a cell [closed]
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, ...
CommunityBot
- 1
0
votes
2
answers
761
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 = ...
CommunityBot
- 1
0
votes
1
answer
10
views
I can not remove data validation with 2 criterias - Function onEdit(e)
I would like to run function onEdit(e) to remove Data validation with these 2 criterias as below:
Remove for columns G,H,I,K if L is "no need".
Remove for columns M,N,O,Q if R is "no ...
CommunityBot
- 1
0
votes
1
answer
312
views
Run a script via the share link (without login) [closed]
There is a script for my Google spreadsheet so that every change in a cell is indicated by a red color marker. When users with a Google account that I have shared to the spreadsheet make changes, the ...
- 43.1k
1
vote
1
answer
22
views
Cannot find active sheet: TypeError: read properties of undefined (reading 'source')
I'm trying to add the current date to a cell in column K when any cell in that respective row is changed.
I found this script and altered it for my situation so I can deploy it as a trigger:
function ...
- 10.5k
1
vote
1
answer
3k
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 ...
CommunityBot
- 1
1
vote
1
answer
2k
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, ...
CommunityBot
- 1
1
vote
2
answers
1k
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 ...
CommunityBot
- 1
1
vote
1
answer
1k
views
Script for GoogleSheets that inserts date, time, and user names of everyone entering text in a specified cell?
I wanted to ask for your help in building a script in Google spreadsheet that would allow users to respond to comments left by different users in the same cell (cell where the initial comment was ...
CommunityBot
- 1
2
votes
1
answer
975
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 ...
CommunityBot
- 1
1
vote
1
answer
29
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&...
- 248
1
vote
1
answer
2k
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 ...
CommunityBot
- 1
1
vote
1
answer
1k
views
Hide/Unhide rows based on values in particular cells
I am trying to Hide/Unhide rows based on values in particular cells, have the following code which works in isolation but not together. Below only makes B121 be active while B55 stops working. If i ...
- 10.5k
1
vote
1
answer
52
views
How do I code 3 series dependent drop down on multiple sheets?
I have a code to run a 3 tier dependent drop down list - it currently works for one sheet in my workbook named "BlankNode" but I need it to work for ~20 different sheets. I tried adding a ...
CommunityBot
- 1
1
vote
1
answer
482
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, ...
CommunityBot
- 1
2
votes
2
answers
56
views
Is setting a trigger for a function to run with a triggered function not allowed?
I would like my function freezeSunday to run at exactly at 1pm on Sunday. Since it does not appear that you can trigger a function to run at a precise time (only at a randomly selected time within a ...
CommunityBot
- 1
0
votes
1
answer
200
views
Copy Row Script & Paste at last Row in the Same Sheet
Do you guys have idea in script how can I copy the details on quotation GE-2108-0271-Rev.0 in few pages and paste the row at the bottom in the same sheet?
Page 1: to be exact I need the number ...
CommunityBot
- 1
1
vote
0
answers
19
views
How do I auto timestamp a sheet when something is moved to it
I am using this function to automatically move a row to a secondary sheet when a set value is entered.
function onEdit() {
var sheetNameToWatch = "Tracker";
var columnNumberToWatch = 4;
var ...
- 43.1k
2
votes
2
answers
1k
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 ...
CommunityBot
- 1
0
votes
1
answer
105
views
Color Cell by using the note in Google Sheets
Whenever I try to use the following script...
function onEdit(e){
if(e.range.getNote()){
e.range.setBackground('green');
}
}
I get the following error...
TypeError: Cannot read property '...
- 43.1k
1
vote
1
answer
20k
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 (...
CommunityBot
- 1
1
vote
1
answer
148
views
Notification email with data from different columns when edit is made to cell in the same row
I've browsed similar questions but I'm a bit flabbergasted.
Google Sheet name: Book List Records
Tab Name: Books sent to Wisconsin
When any cell in column E is (manually) changed in the tab mentioned ...
CommunityBot
- 1
1
vote
2
answers
2k
views
Trigger for onChange on add new row only
I want the trigger which work for 'add new row' only, but not other edit function. Right now the changeType of the onChange are Edit(include add new row), INSERT_ROW (but not add new row), etc., which ...
CommunityBot
- 1
1
vote
2
answers
3k
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 ...
CommunityBot
- 1
0
votes
2
answers
47
views
How to create pop up and add link to a cell
I have a sheets file that requires users to inserts links in the cells of a specific column when they add the information required.
However, to make sure this step is done accordingly, I would like to ...
- 10.5k
1
vote
1
answer
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 ...
CommunityBot
- 1
1
vote
2
answers
6k
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....
CommunityBot
- 1
0
votes
1
answer
598
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 ...
CommunityBot
- 1
0
votes
1
answer
60
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();
...
CommunityBot
- 1
3
votes
4
answers
7k
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.
...
CommunityBot
- 1
1
vote
1
answer
59
views
Timed Triggers for Macros on Multiple Sheets in a Spread Sheet
I'm trying to make a student signout sheet for a whole school. We have one main spreadsheet but multiple separate sheets within that (one for each homeroom, about 25 homerooms so 25 sheets). I created ...
3
votes
2
answers
6k
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 ...
CommunityBot
- 1
0
votes
1
answer
51
views
Why does my onEdit macro error when checking on an edit in a specific cell and sheet?
I've been battling with this for several days and used many previous answers found on these site, as well as a few others, but still can't get my script to run as intended.
I have a dropdown box on ...
CommunityBot
- 1
0
votes
1
answer
34
views
Auto add a row based off a check box
I'm a new user to Sheets! I'm reaching out for help on a problem that I have with trying to create row. I've read a ton of blogs, and watched more Youtube videos than I care to admit without finding a ...
CommunityBot
- 1
1
vote
1
answer
5k
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....
CommunityBot
- 1
3
votes
1
answer
139
views
Add a script trigger to Google Sheet that will work in Android mobile app for merged cells
I'm new here, and I have my first question regarding the following post here:
Add a script trigger to Google Sheet that will work in Android mobile app
function onEdit(e) {
if (e.range.getA1Notation(...
- 2,185
1
vote
1
answer
21
views
Syncing multiple Google Sheets worksheets into one large Google Sheet document
I have several different Google Sheets workbooks with multiple pages that I'm trying to have sync into a master file whenever they are edited. I cannot have all of the people on the separate documents ...
- 43.1k
2
votes
1
answer
3k
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 ...
- 43.1k
3
votes
1
answer
396
views
Google Sheets: On change, delete a specific row if a certain cell is blank
I have a tab on a spreadsheet where if you add a new row to the first row specifically, it breaks the formulas in that tab as they are on the first row. Therefore, if someone adds a row to row 1, I ...
- 63
1
vote
2
answers
47
views
Prevent Google spreadsheet editor from accessing GAS by using detached GAS
The solution is sketched in this post, but it seems key steps are not identified.
This code works fine if in GAS bound to the spreadsheet:
function onEdit(e) {
var sheet = e.source....
- 9
0
votes
0
answers
131
views
Auto create new sheet when new data in column?
I'm trying to create a new sheet on google sheets whenever column B gets a new value. This sheet will be named the value that created it. . I also want to have a function in the new sheet that ...
- 43.1k
1
vote
0
answers
142
views
Script to send email when a cell value is changed automatically by GOOGLEFINANCE function
I have a column of values that pulls data from GoogleFinance using the =GOOGLEFINANCE function in Google Sheets. When the function is working, the column will return a series of figures. Occasionally, ...
- 43.1k
4
votes
1
answer
943
views
Google Sheets Script Editor action not applying to all sheets
I have a Sheets file with a tab/sheet for each month. I am editing the Script Editor to apply an automatic Timestamp when an item is scanned. How do I make the same script for each sheet, but make it ...
- 43.1k
0
votes
1
answer
998
views
Making Google Sheets script work on multiple tabs
Below is my script or code:
function myFunction() {
}
function onEdit() {
var s = SpreadsheetApp.getActive().getSheetByName('Sheet1');
s.showRows(1, s.getMaxRows());
s.getRange('H:H')
....
- 43.1k
0
votes
1
answer
209
views
How to create static/immutable autoincrement column
I am aware of the manual way (add 1,2 in the first 2 rows, mark them, drag the square on the mark-outline down to where u need the numbers)
and a number of ways to create the numbers with formula's, ...
- 43.1k
0
votes
1
answer
929
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.
...
CommunityBot
- 1
0
votes
1
answer
432
views
"#NUM!" error in Google Sheets Script
When trying to Run the following script the result is always a #NUM! error - (Result is not a number) in cell "O5"
Both the cells are in currency format and I've tried changing them to ...
- 10.5k
1
vote
1
answer
48
views
Google Script Substract Function
I want to create a script function that I will use with daily triggers:
function will subtract "Daily Fees" (a cell value that changes daily from "Open Trades" sheet) / from "...
- 43.1k
0
votes
1
answer
30
views
Multiple functions updating datetime stamp in multiple cells [duplicate]
I am trying to update multiple cells based on input in each. The first works fine with a specific text from dropdown but I get no results on the other remaining 3. Here is the script I have:
function ...
- 43.1k
0
votes
0
answers
42
views
Timestamp on change google sheets 3rd party data entry
i have been looking for a way to timestamp my google sheet,
its working if i edit the cell and it work great exactly how i want it, however.
im not the on editing the sheet, its through a 3rd party ...
- 43.1k