Dynamic Select Dropdown

Wappler General Need Help
1

I am trying to create dynamic drop down system
Regions and Districts.
When a user selects a Region in Drop Down 1, the options of Dropdown 2 must change to values attributed to that region.

Two tables in the Db Pictures below REGIONS TABLE

region
region894×388 15.7 KB

DISTRICTS TABLE

districts
districts823×311 13.2 KB

MY FORM
form

I have followed the tutorials below without success. I get the regions to show alright but the Districts drop down does not work. Can some one please help me understand the key things required for this to work both on db side and application side?

  1. https://www.dmxzone.com/go/32764/dmxzone-app-connect-manual/32769/dynamic-dependent-drop-downs-part-2-large-data-sources-3000-records

  2. https://www.youtube.com/watch?v=diTYf5GGJ58

1 Like
2

You need two separate server actions, the one for the second select menu is filtered by the value of the first one.
Here’s how to create a dynamic select menu in Wappler:

4

Well, if you properly filter the query for the second dropdown, then it will change automatically.
Are you sure you are sending the proper value with the get parameter?

1 Like
5

Thanks @Teodor it works now.

1 Like