Questions tagged [google-apps-script-triggers]
The google-apps-script-triggers tag has no usage guidance.
127
questions
0
votes
0
answers
9
views
Too delayed execution of Googld Apps Script Trigger [closed]
I'm trying to clear a sheet of my total spreadsheet every 1 hour.
It is obviously very simple script,
just find corresponding sheet name (SkullKing), and clear certain sections.
function ...
1
vote
1
answer
44
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 ...
- 427
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 ...
- 1
0
votes
2
answers
49
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 ...
- 15
1
vote
1
answer
61
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
1
answer
147
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(...
- 33
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 ...
- 11
3
votes
1
answer
411
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....
- 11
0
votes
1
answer
59
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 ...
- 11
0
votes
0
answers
138
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 ...
2
votes
2
answers
58
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 ...
- 43
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 '...
0
votes
1
answer
214
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, ...
- 1
0
votes
1
answer
443
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 ...
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 "...
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 ...
- 1
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 ...
- 1
0
votes
1
answer
31
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 ...
- 1
0
votes
1
answer
34
views
Is it possible to write a script that automatically triggers some function within a Google Sheets add-on?
I'm using some Google Sheets add-on which pulls information from API databases, and it has both a free subscription and paid subscriptions which add many additional abilities which I don't really need,...
- 135
0
votes
1
answer
110
views
End of day data with trigger in google sheets
I want to copy/paste the values of a specific column into the next column using a trigger at a certain time of the day. The script works when I run it manually, it runs as per 'last run' via trigger ...
0
votes
0
answers
57
views
Fill in one cell if another has had a date selected and move the row when the date is selected and subjected to an onEdit script
I have built a Google Sheet with a lot of data. I have also put in a script to sort data automatically, by date, when new information is input. The new information can relate to past, present or ...
- 1
0
votes
1
answer
251
views
Script in Google Sheet to automatically run after importing CSV files to replace current sheet
I'm going to admit I'm a newbie at scripting. I've managed to write the script that I want but I want it to automatically run after importing the CSV file onto Google Sheets.
I have tried a simple ...
- 3
0
votes
1
answer
264
views
How to speedup Google Sheets script?
I have a script adapted to my needs which was created following this.
I think my script is getting slower over time after adding more entry point in my sheet form.
// Function to submit the data to ...
- 3
1
vote
1
answer
150
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 ...
- 11
0
votes
1
answer
202
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 ...
- 1
1
vote
2
answers
404
views
Help with dynamic dependent dropdown
How do I change this dynamic dependent dropdown list script so it works with my particular Google Sheet.
function onEdit(){
var ss = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var ...
- 59
-1
votes
1
answer
53
views
Sending email with check box formula gives me range error using script
Here is the script for this it keeps saying range undefined and I cant figure it out
function onEdit(e) {
// this script is installed as an installable onEdit trigger
/*
if the checkbox is ...
0
votes
1
answer
500
views
How can I use the onEdit() trigger to timestamp a cell if another cell in the same row is checked "TRUE" in apps script?
I am able to add a timestamp in column 5 using a conditional when I'm comparing the column to a number, but what I am actually trying to do is add a stamp to the corresponding cell in column 5 if a ...
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 ...
- 11
-1
votes
1
answer
288
views
Google Sheets Appscript on apply filter event?
I want to execute a script as soon as I apply a filter to my Sheet. I can't find any event in the App script Docs that will allow me to do this, no onFilter event or anything obvious anyway. Does ...
- 101
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 ...
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 ...
- 11
0
votes
1
answer
1k
views
Trying to run two functions onEdit
I have found two scripts that work independently, but fail when combined. I get this error message
ReferenceError: myfunction2 is not defined onEdit @ Code.gs:3.
I want one field to populate the ...
0
votes
2
answers
226
views
Generate sequential numbers in first column based on value in other column
I'm having a problem implementing a spreadsheet with several sheets that use data registered continuously on the first.
I found a solution with this script on the forum but I don't know how to edit, I'...
0
votes
1
answer
468
views
Depending on Sheet being edited, get a cell value and trigger OnEdit update
This code works but not as intended. The workbook has several tabs (Sheets) and if the user is editing Tab1, then and only then a trigger OnEdit should execute. If the user is editing some other tab (...
- 85
-1
votes
1
answer
74
views
Trigger fails when executing sendEmails function
I created a script to send emails with calculated information from a sheet. The script works beautifully when run manually. I would like this to trigger every minute, but when I try to create any kind ...
0
votes
1
answer
356
views
How to trigger onChange trigger on inserts only
I am trying to create a trigger that sends emails when lines are appended or inserted to a sheet. The problem I have is that the python script that is connected to the google sheet purges sheet "...
0
votes
1
answer
68
views
On Google Forms, can someone edit their response but can't add a new one?
For example "someone 1" edits their response via the link that I have added in the Google Spreadsheet (https://drive.google.com/file/d/1gtULaR5VEfuLOP4f73Z3KofsnksmpSid/view?usp=sharing), ...
- 103
1
vote
1
answer
45
views
How to to get coordinates from addresses coming in from importrange?
I have addresses coming in from importrange and I am using this script to get coordinates.
function myFunction() {
var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Geo 4')
var range =...
- 11
1
vote
1
answer
644
views
Clear Cell Script Google Sheets
I'm looking to run some script to clear the contents of a cell in column E (i.e. E3) when a cell in column I (i.e. I3) is edited ("Complete" is selected from drop down list). I found this ...
0
votes
1
answer
2k
views
Google Sheets script- Copy and paste data from fixed cell to a row corresponding to a cell with current week date
I have a Google Sheets document where I track status of a project as red/yellow green. the live count of Red/Yellow/Green are in Cells BU1 BV1 and BW1 of my summary Sheet. Now I have a table below in ...
- 3
0
votes
1
answer
778
views
How to open a specific tab based on today's date (Google Sheets) [duplicate]
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
1
answer
126
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....
- 135
0
votes
1
answer
935
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.
...
1
vote
1
answer
540
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
1
answer
64
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 ...
- 15
0
votes
1
answer
444
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'...
- 15
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&...
- 21
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 ...
- 21