All Questions
Tagged with triggers google-apps-script
1,519 questions
0
votes
2
answers
62
views
How can I prevent my Apps Script code from timing out?
I have the following code:
function onOpen() {
const ss = SpreadsheetApp.getActive();
ss.getSheets().forEach((sheet, index) => {
if (index < 9) {
const lastRow = sheet.getLastRow();...
- 53
1
vote
2
answers
129
views
onEdit script that only pastes formula within a table's (named) range of rows
The following onEdit function is pasting the formula
=FirstTable[A-EmpNo]*10
Into the entire column (when an Edit is made in Column C)
function onEdit(e) {
var sheet = e.source.getActiveSheet();
...
-3
votes
2
answers
72
views
Event triggering
I can not run OnEdit(e) command in my Apps scripts.
Even with the code given below:
function onEdit(e) {
if (e) {
Logger.log("Event object (e) is not defined.");
if (e.range) {
...
-1
votes
3
answers
123
views
Adjust onEdit() function to collect results onto one tab (instead of separate tabs)
Adjusting the Apps Script onEdit() function to collect results into the "Scheduler" tab (instead the separate "Daily" tabs) is the next step for this request
Click Here (to review) ...
0
votes
1
answer
104
views
Blinking Effect Resets Edited Cell Values (Asynchronous Issue?)
I have a Google Apps Script that creates a blinking effect in Column B (rows 1-100) of my Google Sheet. The script toggles the background color and text of these cells to create a blinking effect. ...
- 1
1
vote
0
answers
37
views
Unable to create Appscript Trigger Again. Error: Something went wrong. Please reload the page to try again
I created a new project and ran the following script. It has deleted my previously existing triggers and even after removing
function createTrigger() {
// Delete all existing triggers to avoid ...
0
votes
3
answers
85
views
How to use Google AppScript to edit a spreadsheet?
I am trying to write a Apps Script function to edit a column in a spreadsheet.
Specifically, I have a column that contains values two values. The values are "Yes" and "No".
Every ...
- 40
0
votes
1
answer
104
views
How to Automatically Trigger a Webhook on New Row Addition in Google Sheets Using Google Apps Script?
I’m working on a feature where a client can link their Google Sheet to my system. Whenever a new row is added to the sheet, the system should send the new order data to a webhook. My initial approach ...
- 93
1
vote
1
answer
110
views
Capturing Google Form data as it gets filled [duplicate]
How can I capture Google form data entered in any section immediately upon clicking the Next button to move on to the next section (before submitting the form)?
Specifically here I wish to capture the ...
- 509
-5
votes
1
answer
178
views
Google Apps Script for OTP Generation [closed]
I tried using a google apps script attached to a google form to generate a one-time password.
The script intends to make the respondent fill out the email id, leaving the OTP field blank. The submit ...
- 509
-1
votes
1
answer
76
views
Trigger on a copied sheet
I am trying to run a Google Sheets App Script whenever a checkbox is ticked.
Other users should be allowed to tick the checkbox.
When ticked, an App Script shows/hides different parts of the sheet.
...
- 43
0
votes
1
answer
97
views
Time trigger .atDate using a cell as a reference
I am trying to make a triger to fire a function on a specific date in the future. I am using the .atDate method, but I want to use a cell from the sheet as a reference.
My code is:
`function ...
-1
votes
1
answer
66
views
Google Apps Script for inserting data onformsubmit is executing, but not inserting any data
I'm trying to reactivate scripts in Google Sheets which broke when my colleague's account got deactivated. He created them. They functioned before he left.
Now, these only work when I manually submit ...
- 7
-3
votes
1
answer
107
views
Calendar event updates with a Trigger
is it possible to get Calendar event updates and new events with a calendar trigger. so, that only updates and new events are pulled. and then the properties (description, start date, end date, etc..) ...
- 55
-1
votes
1
answer
54
views
How to run Google Apps Script - Weekdays only
I have a trigger setup to send a Google doc to colleagues via email, daily between 9-10pm. It works perfectly. However, I need this to only run on weekdays.
Below is my code. At the very top I ...
- 1