I have a spreadsheet, with 2 scripts embedded, that monthly is sent to some accounts (teachers) inside my domain. One script reads a form (exam) and write the results in the spreadsheet, the second script transfer the final evaluation (the teacher must add other info to the exam scores) to another public spreadsheet where the people can see the results.
Everything works fine, except that the first run of one of the scripts, asks for Authorization. I'd like to avoid that and I read many articles about Authorize scripts, but I couldn't find the solution.
I don't need to Publish an App, that is far away from my needs and my abilities. I explored Add-on feature, but in some forums I read that there are limits for the Add-on capabilities and possibly it doesn't work between forms and spreadsheets.

So, is there any option to distribute a script inside my domain and the people are not required to Authorize it?

CodePudding user response：

You can add an installable onEdit trigger from your account, trigger script function if specific cell is updated by the rest of the user.

CodePudding user response：

Ok, I understand that is impossible to avoid Authorization. Probably I don't have a complete vision of the whole Drive universe, but I'd ask to the developers to consider the idea to establish a mechanism that permits to Authorize a script inside a domain.