Editing Protected Sheets Through Google Apps Scripting

[peterpiper]

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.

 

[gsal]

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