Editing Protected Sheets Through Google Apps Scripting

  • Thread starter Thread starter peterpiper
  • Start date Start date
  • Tags Tags
    Apps Gas Google
Click For Summary
To protect a Google Sheet so that it can only be edited via scripts, users can set the sheet to "View Only" for collaborators while using Google Apps Script to manage interactions through buttons. This setup allows for actions like claiming tickets and editing details without granting direct editing access to the sheet, thereby preventing data loss from careless edits. While some users question the need for a custom solution over existing ticketing systems, the approach serves as a cost-effective alternative for those who prefer a tailored setup.
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.
 
Computer science 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.
 
Thread 'ChatGPT Examples, Good and Bad'

Thread 'ChatGPT Examples, Good and Bad'

I've been experimenting with ChatGPT. Some results are good, some very very bad. I think examples can help expose the properties of this AI. Maybe you can post some of your favorite examples and tell us what they reveal about the properties of this AI. (I had problems with copy/paste of text and formatting, so I'm posting my examples as screen shots. That is a promising start. :smile: But then I provided values V=1, R1=1, R2=2, R3=3 and asked for the value of I. At first, it said...
View full post »

Similar threads

Using physics to prove my innocence
  • · Replies 1 ·
Replies
1
Views
2K
BRS: PKI Cryptosystems for SA/Ms: A Tutorial
  • · Replies 13 ·
Replies
13
Views
4K
PF Fan Fiction: Mathematicians in Love
  • · Replies 2 ·
Replies
2
Views
4K
  • Sticky
Physics Forums Global Guidelines
  • · Replies 2 ·
Replies
2
Views
503K
Kerbal Space Program - Rocket Design Basics
  • · Replies 2 ·
Replies
2
Views
9K