google spreadsheet script - permissions to protect sheet -

google spreadsheet script - permissions to protect sheet -

i have next spreadsheet:

-template (protected)

-current working sheet

-older sheet (protected)

-even older sheet (protected)

this spreadsheet shared few users, , have write permission in "current working sheet". 1 time considered completed, created button in "current working sheet" assigned script. when ran owner, script:

renames "current working sheet" "something older" protects "something older" sheet duplicates "template" sheet new "current working sheet"

it works fine wen ran owner, when button triggers script pressed 1 of users whom shared document with, step (2) fails, meaning sheet can't protected. suspect permissions issue finish newbie in google scripting, asking help here. there way create sure no matter presses button, assigned script ran owner?

thank you

you cannot have button user @ keyboard clicks invoke script runs owner. see doc authorization here. said, can have button set value or update record script on time based trigger checks. flow work well:

user updates working sheet user clicks i done! button script adds row hidden sheet called things scripts do indicates of now, working sheet should archived every hour, script checks things scripts do , updates sheets , permissions described above

google-apps-script google-spreadsheet