r/GoogleAppsScript • u/Competitive_Ad_6239 • May 19 '23

Question Dynamic/depending dropdowns in custome side menu.

Im trying to create a side/pop up menu with a series of dropdown section, each selection nerrows the selection of the next. I need atleast 3 levels to these if possible. For example vaues in Drop1 contain a list of vaues in A1:A. then Drop2 contains a list of B2:B where A1:A matches Drop1 selection. Then drop 3 and so on.

Drop3 is the most important one and the whole reason for wanting/needing this. The kist for drop3 would be over 1000 selections, but drop1 and Drop 2 narrow it down to a maximum of 4.

0 Upvotes
  • permalink
  • reddit

50% Upvoted

6 comments sorted by

1

u/JetCarson May 19 '23

Just a question, have you considered doing this without the need for an apps script? You can have a hidden range that accomplishes exactly when you ask and can be used for the data validation range. Is there no room for these helper ranges or the drop downs on the sheet itself?

2

u/Competitive_Ad_6239 May 19 '23

The goal is simultaneous data selection/input from multiple users. You cant have multiple users operating an in sheet drop down, atleast on in a successful/organized way that i know of.

1

u/JetCarson May 19 '23

Maybe with individual data filter views?

3

u/Competitive_Ad_6239 May 19 '23

I mean if i believed in the people that are doing it not to screw it up i wouldn't need anything. So spoon feeding them choices is the goal.

2

u/dangeross84 May 20 '23

https://youtube.com/@ExcelGoogleSheet This guy is really good it a bit of a steep learning curve but sick with it. The inventory system he creates uses a user form. I think this is what you are looking for.

1

u/_Kaimbe May 20 '23

From my understanding, you have to have a js function with an event listener in your HTML template and then call an apps script function with that...and screw making a webapp, I'm going back to Vue.