There is a Google-table created by the Owner. The owner in it opened the Script Editor and created the script "Kod.gs". The owner has given the Programmer the right to Edit the Table. The programmer created the necessary functions and tied them to a call on the image (button).

Problem: When re-opening Google-Table by Programmer - "Function not found". Perhaps at this time other users tried to run the script and gave confirmation for authorization. Now you enter the editor - you exit and now the launch works.

How and where to check the rights to run the script. Maybe the right to run "all users" who have access to Google-Table?

  • If the reason was in authorization, an error message would indicate this. The reason is different. - user176149

1 answer 1

Let's call it: "user inertia when working in an application with autosave".

We are accustomed to the fact that applications in the browser automatically save the data entered by us. They monitor the quality of input, notifications and warnings. Google Drive with its applications is not an exception with one "but".

But Google Apps Script Editor does not automatically save the entered code, but leaves warnings.

Let Bob and Alice work in the same editor with one file from under their accounts. When Bob entered the code, Alice still does not see it, because Bob did not press CTRL+S Bob has saved the code, Alice still does not see it, because Alice has not updated the browser page. Alice has updated the page - the visible part is relevant. Let's call this state of affairs - "Состояние Ч" .

Alice continues to frantically press F5 , expecting more and more up-to-date code from Bob (a). Ok, the "Состояние Ч" smoothly moves in time, and the derivative of the состояния function for this time has a tangent at all points.

Alice was distracted for a while, which allowed Bob (y) to enter and save enough text. Returning, Alice lost her frenzy in favor of practicality, order and curiosity. She decided to check how the Bob code (a) works. She launched the script, and a decent and practical editor, which does not possess obvious signs of an application that can auto-save, executed it. Note that performed correctly, without flaw. And for greater loyalty, he also made a push of all recent changes. Whose only? Of course Alice. She was in the "Состоянии Ч" , while Bob has already prepared a new increment for this state. The aforementioned tangents will not appear here anymore, there will be no extremum point, here ... Is there a function of "Сотояния Ч" does not "Сотояния Ч" ?

Not exactly, a kink is possible. But only if Alice is vigilant, Bob will report it (y), and Bob, do not be a fool, will keep its increment over the copy of Alice. If Bob at this time updated his page or closed his copy of the editor, then his efforts could sink into that place where that same “does not exist” exists.

Is this right or not? In my own conviction, the editor indirectly shows me that Bob has no experience with the editor, since it was in his interest to take action, and Alice ... However, if she pays, then she can.