Dropdown Menu Condition

axel.schallies · 2020-09-13T15:06:16.513Z

I’m trying to build a form that starts with two dropdown menus. The thing is that the second’s choices depends on the first’s answer. I would like to get t US State related to the city… but now I’m getting all city even tough I select one US State. Where and how can I use the condition in the second dropdown menu (City)
Any ideas how to enter coding?
Thank you

ambroisedlg · 2020-09-13T15:10:40.901Z

Hey @axel.schallies

Sounds like both your dropdowns should be dynamic. How are you getting the data to match a city to a state? Is it via your DB or via API?

Ambroise

Need extra help?

Book a free 15 minutes call - happy to help if I can

axel.schallies · 2020-09-13T16:33:30.850Z

Hi @ambroisedlg,
Both dropdowns are dynamic and I’m using my own DB. How can I connect them?
Axel

ambroisedlg · 2020-09-13T16:44:45.834Z

@axel.schallies

I’m not sure if you did this already, but in your DB you’ll need to have a data type ‘City’ and a data type ‘State’, which needs to include a field ‘Cities’ (list of Cities).

Set your first dropdown to data type = States and data source = Search for States (no constraints)
Set your second dropdown to data type = Cities and data source = Search for Cities, constrained by City is in Dropdown State’s Cities

Here is a quick example:
Demo: https://ambroisetestapps.bubbleapps.io/version-test/dynamic-dropdowns?debug_mode=true
Editor: https://bubble.io/page?type=page&name=dynamic-dropdowns&id=ambroisetestapps&tab=tabs-1

Hope that helps
Ambroise

Need extra help?

Book a free 15 minutes call - happy to help if I can

axel.schallies · 2020-09-13T16:54:34.979Z

Yes, this works… I need to tweak my DB but I can see the settings.
Thank you…

everymail3 · 2020-11-18T05:36:55.173Z

is there an api for this? i want to provide a dropdown list with states and cities. I dont want to manually enter every city in a state. Is there any api which does this?

axel.schallies · 2020-11-19T12:39:19.603Z

ambroisedlg,
I just saw your message… What I did I change field type of choice to text. This way it will grab & show only one the state from my database… I hope this helps

image403×765 31.8 KB