Interface dropdown tool selection

Question

I have attached file which has Country and state names

i need to create two dropdowns. One should have India, USA and SouthAfrica.  Based on the country selection,  second dropdown values should change accordinrgly.

For ex: If first dropdown (country) value selected as USA, second dropdown value should show as NY, NJ, FL & TX.

NOTE:  These are the sample data.  state names will have more than as mentioned in the table.

Country details.xlsx

apathetichell · Answer

Hey @LuckyRaju did you read up on chained apps? Chained apps are two apps - one which calls the other. the subset of entries which forms the basis for the second app's dropdown is created by the first app. That is how you get it to work with chained apps.

I have attached the tree version. In this case - app 1 creates the tree file - and app 2 loads the tree. Feel free to build your own logic in app 2. the advantage to the Tree vs the Dropdown is that if the tree file remains static this would not require chaining and could be a solo app.

Tree tool country.yxzp

LuckyRaju · Answer

Thanks for your reply.

I have built the flow based on your inputs. However i am not able to filter states based on Country selection.  How to connect both the  Dropdowns?

First Dropdown listing all the country names which are in spread sheet, which is fine.

Second dropdown listing all the state name.  It should only list associated state names for the country which is selected in the first dropdown.

Please help me correct the flow

Country details.xlsx

CountryTest.yxwz

apathetichell · Answer

There are two ways to do what you are trying to do:

1) Chained app. - as @acarter881 pointed out this is the standard way.

2) Tree tool. You click one. that expands to choice 2. this is more complicated.