Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Editing Protected Sheets Through Google Apps Scripting

  1. Oct 20, 2015 #1
    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.
  2. jcsd
  3. Oct 23, 2015 #2
    Any particular reason why you do not use a real poor man's ticketing system? There are several out there, very nice ones.
Share this great discussion with others via Reddit, Google+, Twitter, or Facebook