onEdit script does not start for users under anonymous access

145 views Asked by At

it's my 1st public question, hope I'm clear enough.

Here is the context:

  • I have created a spreadsheet as a template, including an "onEdit script"

  • I have made a copy of the spreadsheet created above, editable by everyone who has the link

  • when I open this copy and :

  • edit it, under my account (as owner), script works :)

  • edit it, under another google account script works :)

  • edit it, from an anonymous access, I can edit the sheet, but the script does not work :(

I have already read many posts like https://support.google.com/docs/thread/10422866?hl=en&msgid=10677830, also tried this : https://support.google.com/docs/thread/41307278?hl=en&msgid=41569467. Got the same difference related to user access. :(

In fact, I need to share sheets with publics (without expecting Google account) and, because they are invited to, I need to determine which cells they may have edited.

Any idea will be greatly appreciated ! :)

0

There are 0 answers