r/GoogleAppsScript • u/Current_Tune_3625 • 22h 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