Hello everyone,
I am trying to build a form with 2 choice selections :
one for countries
one for cities
Once a country is selected I would like in the second choice field to display only cities related to the country selected. Is it possible to that?
Assuming your Cities table has a Country column, you can create a filter based on Screen Value. Imagine my Choice component is for the Cities choice, and the Category is the Country name that would be in your Cities table. It should be a very similar setup for you. When filtering by Screen Values, the filter looks at the values in the other components on your screen.
So, what you do is filter the Cities where the Country column in that cities table is equal to the the Screen Value of the selected Country choice.
Yes, it is possible and easy… add a country column for cities, and use the if-else column to extract cities with the country selected in the first choice.
You’re most likely writing your choice back to the same column that you are using as the source of your choices, so it’s just overwriting them. You should be writing to a separate column, or your choices should be in a separate table.