Cascading Dropdowns

Questions
1

Hi. I have a dropdown which lets a user select a static choice of North/South/East/West (field is direction). Once the user has selected, a 2nd dropdown will list the options specific to the direction choice (eg North -> A, B, C; South -> D, E, F…). In this case, the choice selected (A or B or C or D or E or F…) is supposed to populate a field called type.

I have tried hiding my 2nd dropdown and only show the relevant dropdown based on the 1st dropdown. It almost work but it broke when I’m trying to submit to a database. The 2nd dropdown is not able to populate the field type

Appreciate any advice on how to tackle this. Thanks

2

If you set up your database properly, it should work fine.

Datatype 1: (1 field)
NAME
North
South
East
West

Datatype 2: (2 fields)
NAME DATATYPE1
A North
B North
C North
D South
E South
…and so on…

Dropdown 2 is hidden unless Dropdown 1 is not empty

Furthermore, Dropdown 2 is Dynamic, do a search for DataType2, constraint: DataType1 = Dropdown1’s value

3

Thanks Robert! :slight_smile: I used a solution using option sets. link below Cascading Filters using Option Sets in Bubble

1 Like