R
R
Rafael2662021-06-07 21:28:44
Google Apps Script
Rafael266, 2021-06-07 21:28:44

Why does the script in Google Sheets not work after sharing the file with another person?

The script sets the date and time automatically when filling in the cells. Everything works for me, but if you give access to another user, this script does not work for him. A if you change the owner (see example below). Does anyone have experience and know how to solve the problem?
I give an example:

  1. Owner and creator of the table and scripts - let's call A
  2. User 1 - B.
  3. User 2 - B.


In this version , the scripts work only for A.
if A transfers the owner to B , then it works for A and B.
If B transfers the owner to C , then it works for A and C.

Tried all the different options with transferring users. Does not help. No windows open. On scripts and on the table, editorial access is given. Tried to copy the table - the same thing.

What could it be?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
G
Grigory Boev, 2021-06-08
@ProgrammerForever

Make an edit trigger. Rename the onEdit (event) function itself so that it does not work as a simple trigger, for example, in onEditTrigger (event). Then the script will be executed on behalf of only one user. Not sure if it will help, but worth a try.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question