All Questions
14
questions
0
votes
1
answer
31
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
61
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 ...
0
votes
1
answer
33
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 ...
0
votes
1
answer
41
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, ...
0
votes
0
answers
37
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
40
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 ...
0
votes
0
answers
90
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
votes
1
answer
66
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
479
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 ...
0
votes
1
answer
251
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 ...
0
votes
1
answer
149
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 ...
0
votes
2
answers
516
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 ...
1
vote
1
answer
474
views
Why is my "limit exceeded" for some of my Google Apps scripts that are using time-based triggers?
I seem to be running up against some kind of unspecified limit with my G Suite account while using Google Apps scripts, but I'm not sure what the limit is and/or how I should adjust my workflow.
I ...
2
votes
0
answers
68
views
Unable to create onFormSubmit trigger from Sheets add-on
I'm using Google Apps Script to make a sheets add-on where it'll create an installable onFormSubmit() trigger to a Form Response sheet by given ID. I've published the add-on as Unlisted & ...