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.
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook

Similar Threads - Editing Protected Sheets Date
Adobe Digital Editions takeover of pdf files Jun 7, 2017
X86 Protected mode Jul 14, 2016
Video editing software for presentations Feb 11, 2016
MySQL DDL Column Edit is Disabled. Why? Jan 19, 2016
Editing video Jun 18, 2015