I am familiar with how to create a dynamic dependent drop-down on sheets, up to maybe 2 levels. I need some help with how I can do that with Glide.
So for example, I’d like to create something like a name sorter let’s say.
Where in the first choice would be:
Choose your favorite letter
(drop down displays A to Z, 26 choices)
Example: User chooses a Letter: B
The second drop down in my Form, will depend on the choice above.
(drop down displays only names that start with the letter chosen, so anywhere between 5 to 150 choices let’s say depending on the letter chosen)
Example: User sees the names Bob, Bill, Bean, Barry, Bing, Blue
User chooses ‘Bing’
The third drop down should then depend on the previous choice again, showing all written variations of that name (anywhere from 1 to 10 varied spellings)
User sees Bing, Beeng, Bng, Bhing, Bheeng l
User chooses ‘Bng’
Once user clicks submit it should input in my sheets.
So far I’ve been able to do up to the first 2 drop-down t it seems like a long workaround. Is there anyone that can help?
It uses:
(1) A column for the letters
(2) A column for each of the letters with the names in each letter
(3) A column for each of the names with the spelling/misspellings for each name
Hello Jaime, could you please explain this a little more?, I need to so something like this. I need a choice component to show countries and then a choice component to show cities of the country selected in the previous choice component.
I don’t understand how to set the visibility conditions, also could you please share your sheet?
Okay so your options are similar to what we tried to do and it works with small sets of data, i was wondering if it’s possible to do something in the sheets using filters?
Because there will be somewhere around 100+ choices for the first level, 5 to 100 per each choice on the 2nd level, and then 2 to 20 for each choice in the 2nd.
It seems like I could work it within sheets up to the 2nd, but not the third using filters but can’t seem to make it work in glide without looping
It takes a decent amount of time to sync the options (around 5 seconds), and it requires that you add a record for the letter first, and then edit the record for choices for name and spelling: bw16i.glideapp.io
@Jaime Thanks a lot for your help. Your solution worked perfect for me, It is true that populate each citie is tedious but it works fine. I hope glide implement some tool to to this easily in the near future.
I’ll throw my example in here too. Check out the Dynamic Filter in https://concepts.glideapp.io/. It’s probably very similar to @gvalero’s example and uses relations. The only visibility I use is to show 1 of 2 maps based on if both choice components combined have matching related items. Each map uses a different relation.
I tried to emulate your setup, borrowing from both the public and private tabs to amend a form I already have in an app. It seems the Relation in public view that makes this work is not compatible in a form setting.
I’m looking to set up two choice components (you can see in a modified version of your app: dynamicchoices2.glideapp.io ), Top-level is Products, drill-down is Box Size. Once a user makes those selections (among others), they submit the form. Right now, in my app, I have form output on a completely separate sheet, not mixed in with product info.
Do you know of a workaround or am I overlooking something?
but can’t seem to make it work in glide without looping
