Interface dropdown tool selection

[LuckyRaju]

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. 

[acarter881]

Hello, @LuckyRaju.

Have you looked into Chained Apps?

The idea is that a selection made will influence what data are shown to a user. In your example, it's a country selection then it's the relevant state data that are shown to the user.

I have a solution here with a yxzp attached that shows one method for configuring a drop down.

Please let me know if you need further assistance/clarification.

[apathetichell]

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.

[LuckyRaju]

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

[apathetichell]

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.