Stephen Holinaty
unread,Dec 20, 2021, 3:08:42 PM12/20/21Sign in to reply to author
Sign in to forward
You do not have permission to delete messages in this group
Sign in to report message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to Google Apps Script Community
Hoping for some help in finding a missing role / scope.
I have a google sheet, that myself and others have EDIT permissions on.
They can open the sheet, make changes, etc.
There is an Apps Script tied to this sheet, that does... stuff. and the 1st thing it does as part of OnOpen, or a run, is write a console message.
my test user has been given explicit EDIT access to the apps-script as well.
when anyone on my current team tries to open the document, the OnOpen() runs flawlessly, and logs.
when anyone on my team tries to run the second script, it runs flawlessly.
however when our target users (who have EDIT permission to the sheet and the script) try to run the scripts, they simply time out. no errors, and in the Execution Log, it says "failed" with 0 logs.
Has anyone experienced this before, or know of a solution? I would have thought giving EDIT access to both the sheet and doc were sufficient.
Thank you in advance!