Editing Protected Sheets Through Google Apps Scripting

  • Thread starter Thread starter peterpiper
  • Start date Start date
  • Tags Tags
    Apps Gas Google
Click For Summary
SUMMARY

To protect a Google Sheet so that it can only be edited via Google Apps Script, users can implement specific permissions settings that restrict direct editing. This method is particularly useful for creating a simple ticketing system where actions like claiming tickets and editing details are managed through buttons linked to scripts. The discussion highlights the importance of safeguarding data from careless edits by multiple users, emphasizing the need for controlled access through scripting.

PREREQUISITES
  • Familiarity with Google Sheets and its sharing settings
  • Basic understanding of Google Apps Script
  • Knowledge of script triggers and button functionalities in Google Sheets
  • Experience with data protection mechanisms in Google Sheets
NEXT STEPS
  • Explore Google Apps Script documentation for creating custom functions
  • Learn how to set up protected ranges in Google Sheets
  • Research best practices for implementing user permissions in Google Sheets
  • Investigate existing ticketing systems to compare features and functionalities
USEFUL FOR

This discussion is beneficial for Google Sheets users, developers utilizing Google Apps Script, and anyone looking to implement a controlled ticketing system while minimizing data loss from user errors.

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.
 

Similar threads

Using physics to prove my innocence
  • · Replies 1 ·
Replies
1
Views
2K
Graduate 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
505K
Kerbal Space Program - Rocket Design Basics
  • · Replies 2 ·
Replies
2
Views
10K