Help filtering using a value selected in a dropdown

[scott]

Hi @DrNinjamonkey,

I will admit, I have not created a dropdown selection to filter a table in Wappler. What I have done consistently is use a text filter to filter a table.

This might help you with the dropdown selection that you are trying to do. It would need to be modified based on your needs because the original poster was using dropdowns to populate other dropdowns.

Dynamic Dependant Dropdown Menus

In a perfect world Dynamic Dependent Dropdown Menus are really easy, and generally for me quite reliant on the database structure. When I create a site and i know before starting that it might use geographic entities I might have a database structure like this. Continent Table id continent 1 Africa 2 Europe 3 Asia Country Table id country continent foreign key id 1 Algeria 1 2 Angola 1 3 Benin 1 4 Botswana 1 5 Armenia 2 6 Albania 2 7 Andorra 2 8 Austria 2 …

If you want to filter the table based on a text input, you can do that by following the steps here: Filtering Database Query with a Text Input