Editing Protected Sheets Through Google Apps Scripting

  • Thread starter Thread starter peterpiper
  • Start date Start date
  • Tags Tags
    Apps Gas Google
Join the discussion
Registration is free. Ask a follow-up in this thread, or start your own.
Sign up Log in
1 reply · 1K views
peterpiper
Messages
12
Reaction score
0
Does anybody know of a way that I can protect a Google Sheet in such a way that it can only be edited via scripts?

Ultimately I'm putting something together that acts as a very poor man's ticketing system. I have information displayed in a sheet and a set of buttons with scripts attached to them to do actions such as claiming tickets, open/close ticket, edit detail, etc. The last time I shared a sheet like this with multiple people in my workplace, data was lost almost immediately due to carelessness.
 

Discussion

Physics news on Phys.org
Any particular reason why you do not use a real poor man's ticketing system? There are several out there, very nice ones.