Editing Protected Sheets Through Google Apps Scripting

  • #1
14
0

Main Question or Discussion Point

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.
 

Answers and Replies

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

Related Threads for: Editing Protected Sheets Through Google Apps Scripting

  • Last Post
Replies
4
Views
694
  • Last Post
Replies
5
Views
245
Replies
11
Views
255
Replies
2
Views
883
  • Last Post
Replies
9
Views
2K
  • Last Post
Replies
11
Views
2K
  • Last Post
Replies
14
Views
3K
  • Last Post
Replies
16
Views
2K
Top