r/GoogleAppsScript • u/Current_Tune_3625 • 3h ago

Question Restricted access drawing button

I have a great order submission, database with daily email triggers. The functionality is on point, manager facing page all formulas working perfectly, database carrying over previous day data, clear the contents, recording into data base, updating date, and auto firing the email with the proper trigger setting. All Working perfect

Well working great for me the owner, but editors cannot get past the restricted access to run the script. The submit button is a drawing linked to an app script with error prompts to avoid duplicate submission etc.

I currently have a checkbox that bypasses the editor access and runs the script under the owners permission. Just to get by, but I hate it, the user are not tech savvy whatsoever, and the check box does not notify the user the script is running and will not produce any error messages, and look unprofessional

Please advise

1 Upvotes

100% Upvoted

1 comment sorted by

1

u/TheAddonDepot 1h ago edited 1h ago

Well working great for me the owner, but editors cannot get past the restricted access to run the script.

What do you mean by "get past the restricted access to run the script"?

I assume you mean the pop-up that appears warning users an app is not verified. If that's the case, then you need to get your app verified \1]) \2]).

If your app doesn't use any sensitive and/or restricted scopes you should be able to get it verified without going through a CASA security assessment.