OPTIONS OF INPUT FIELD TO ONLY SHOW ITEMS IN RELATION TO THE VALUE IN PREVIOUS INPUT

[farajabien]

I'm working on an app that requires one to pick a country and then a city. How do I make my dropdown options to only show options based on the country selected in the previous input.
So if I pick England as a country, I shouldn’t be able to see cities from France when I'm selecting a City.

Here is an example:

As you can see I have selected province as province 1 and it only has 2 districts district1 and district2

How do I make the input dynamic in that you are only allowed to see districts from the chosen province as options???

[melohagan]

Hey @farajabien

So if I pick England as a country, I shouldn’t be able to see cities from France when I'm selecting a City.

This functionality will need filtering added to a relationship picker. Work on that was started here: #8897

This may help as well: https://docs.budibase.com/docs/filter-by-relationships

[holgerbermeo]

It doesn't solve the problem, I'm wanting to do something similar. What we would like is in a form, to be able to choose from a list options that are filtered by another table.

For example, in a form to register "intervencionvial", I would like to choose (1)"parroquias" that only belong to one (2)"canton" and not for the entire list to appear

For example, that column should filter the options in (1) "Parroquias" once I have chosen a (2) "Canton"

[holgerbermeo]

Another more visual example. I have some data A-B-X and on the other hand I have 1-2-3-5-6-7-8-9-10, but 1-2-3 is inside A and 5-6-7 is within B and 8-9-10 within X. If in this case I choose option B in my first question, I only want the data related to B to appear, which are 5-6-7

[melohagan]

Hey @farajabien @holgerbermeo

Just to let you guys know, you can now filter relationship pickers which should solve for this use-case!

There is a recipe tutorial you can look at here: https://docs.budibase.com/docs/cascading-dropdown-filters