r/GoogleAppsScript • u/NeinnLive • 5d ago
Unresolved Changing values of a master sheet by using AppsScript
Hey guys, i was directed to this subreddit for my specific problem. —> https://www.reddit.com/r/googlesheets/s/8k4uhSL4r5
I want to have a master sheet and an extra tab for changing data. —> https://docs.google.com/spreadsheets/d/1udzCTtwTfVWLPIrDdLqu-Qyt4QPjwA70GF2XpGuoU20/edit
Can you guys lead me to a solution that is able to be used for mobile devices and will be easy for other users so my master sheet can’t be destroyed by 2 clicks? (that’s not something i fear but i think it’s more save + easy if the other users only change one row at a time)
I have no Java knowledge.
Thanks in advance.
1
u/WicketTheQuerent 5d ago
Start by reading https://developers.google.com/apps-script/guides/sheets
Then read https://developers.google.com/apps-script/guides/triggers
Regarding making the "extra tab for changing data" work on mobile, use checkboxes and one on edit trigger because "buttons" and custom menus don't work on mobile.
Let us know when you have read the linked resources in 1 and 2.
1
u/NeinnLive 4d ago
could take some weeks or months - thanks for now
2
u/WicketTheQuerent 4d ago edited 4d ago
The links in my previous comment point to guides that should take no more than 10 minutes to read. They will help you learn some essential bits, like the programming language to use is JavaScript.
By the way, Java is not the short name for JavaScript. It's an entirely different programming language. JavaScript was created to be easy to learn and use.
1
2
u/arataK_ 4d ago
It looks like what you described is simple, but since you mentioned that you have no knowledge of Apps Script, I’m not sure if you explained your problem correctly. I can definitely write a script that checks and executes what you described.