All Questions
17 questions
0
votes
0
answers
50
views
When do time-driven triggers initially go off?
I'm using time-driven triggers in my apps script to get it to run my code every 2 hours. The problem is that there are reasonably specific times I would like this to happen - it doesn't have to be ...
-1
votes
1
answer
92
views
Why is oldValue ALWAYS undefined upon entering function onEdit? [closed]
In my script, I want to compare the value that has just been entered into a cell with whatever value was previously in that cell, if any.
Per https://developers.google.com/apps-script/guides/triggers/...
1
vote
1
answer
115
views
Archive a row after a dropdown status is selected on multiple sheets
I have a file with three sheets. On all three sheets, when a certain dropdown selection is changed to "Cleared" I want the script to copy that row of data over into a hidden archive sheet ...
0
votes
1
answer
76
views
How do I stop trigger error notiification email messages
How do I stop these messages? I have not used this for years and I do not see where to resolve. I click on the "click here" and it says that I have no triggers set up.
I click on the "...
1
vote
0
answers
110
views
Avoid/Clear UrlFetchApp cache when fetching a RSS feedin Google Script
I encounter a problem on Google Apps Script.
The use of the script is to get RSS feed URLs to fetch from a Google Sheet and if new article(s) are detected (comparing the GUIDs from the fetch to a GUID ...
- 11
0
votes
1
answer
37
views
Google workspace add-on install trigger with toolbar failed
It is very weird! The same code(attached below), user take diff installation ways, diff effects.
Success situation:
User A -> click menu item in Add-on menu to install trigger(Google sheet onEdit ...
- 1
0
votes
1
answer
45
views
Onedit update cells use row ID in B2 to locate row line
I'm trying to make a customer profile page to make viewing selected clients easy on the eye and to edit. I want to edit and update on edit the data from the easy on the eye section (cells B3, B5, C3, ...
- 21
0
votes
0
answers
38
views
Trying to get the minute interval at :00 and :30
In my code that was customized, I have not added any time sequence to be add, and in the trigger I even made a minute interval for every 30 minutes and made sure to submit the interval at 00:00 AM at ...
0
votes
1
answer
43
views
How do I script multiple "hideRows" commands?
My goal is to create a checkbox that hides several rows of information below it for every month.
I have very very little knowledge of coding but have successfully been able to write a simple code for ...
- 3
0
votes
0
answers
120
views
G Apps Script "We're sorry, a server error occurred." when installing a trigger
I'm attempting to install an onFormSubmit trigger to a Google Sheet. When running the setTrigger function below, I receive this error:
Exception: We're sorry, a server error occurred. Please wait a ...
- 1
-1
votes
1
answer
73
views
Installable trigger needs to grab email of user who edited, but is only accessing mine
So I've got a spreadsheet that lists work to be done via an imported range from another file. Users have a dropdown of validated data that when they select the status of this work it searches the ...
0
votes
1
answer
562
views
What happens to script triggers when I delete the user that made them?
I want to make a username available for someone else named after the old Tech Admin, however they have a ton of triggers running.
If I delete this user, is there a way to preserve these triggers or ...
- 1
0
votes
1
answer
284
views
Can a web app user schedule an apps script trigger to send an email at a given time?
I am trying to find out if the following scenario is possible with apps script:
I deploy a web app that is executing according to the user accessing it.
user opens the deployed web app and authorizes ...
user9041424
0
votes
1
answer
153
views
Configuring an Installable Trigger in Apps Script for a Company Wide Add-on
So I have created a G Apps Script and I need to manually install the onEdit trigger. However I ran into an authorization issue, so now I am trying to do it this way. I am following the following ...
- 1,334
0
votes
2
answers
774
views
Too many simultaneous invocations 50 different scripts and triggers
I'm setting up an inventory management system to track stock. I have created a spread sheet with 50 columns adding the various different stock we carry. I have added a formula to subtract as the stock ...
