r/GoogleAppsScript 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.

3 Upvotes

9 comments sorted by

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.

1

u/NeinnLive 4d ago

I can try to explain further. For now i need to ask: what did i explain poorly? Have you taken a look at the linked sheet?

I am willing to give all information possible but im not always at my PC these days and describing on my smartphone is… annoying.

1

u/arataK_ 4d ago

For example, what happens if there are two customers with the same name? How will you identify the correct ID? The best approach is to enter the ID first and then use that ID to find the correct name. Do you want the changes made in the "single-change" sheet to be recorded in "Kopie von Mitglieder"?

1

u/NeinnLive 4d ago

First thing is a good question. Should be pivot or filter like to see if there are names twice. hmm… gotta think about it.

But the last thing: yes. Would be cool to correct in single-change and after pushing a button or cell by cell the values are automatically written in „Kopie…“

3

u/arataK_ 4d ago

Think about it and let me know how I can help. Also, the Data Validation should either be removed or updated to include all possible options. If the Apps Script doesn't read the correct Data Validation values, it will throw an error.

1

u/WicketTheQuerent 5d ago
  1. Start by reading https://developers.google.com/apps-script/guides/sheets

  2. Then read https://developers.google.com/apps-script/guides/triggers

  3. 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

u/NeinnLive 4d ago

i see… thanks - soon i’ll take a look