combination of interface tools - Radio button and text box / drop down

[pgayath1]

My query is based on the selection of option from Radio button, I need to give the text  input / select the input via drop down and search a database.

For example, I need three radio buttons, based on one of the selected options from radio buttons, will provide input  via text box / drop down.

Using the input, database needs to be searched and pull appropriate records.

How can I achieve this?

Please provide me the workflow.

Thank you.

[BrandonB]

Are you planning for the drop down options to be fixed values that don’t change over time, or do you also need to get the list values from the database each time?

[pgayath1]

Yes, I need to get the list values from the database if the data gets updated.

Based on the radio button selection, searching values should get added from the database to the drop down.

Is it possible to implement?

Thank you

[BrandonB · Accepted solution]

You can use what are called Chained Analytic Apps in order to do so. Here is an example: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Chained-Alteryx-Analytic-Applicatio... 

And here is an interactive lesson on chaining analytic apps: https://community.alteryx.com/t5/Interactive-Lessons/Chaining-Analytic-Apps/ta-p/243120

The thought would be that your first step retrieves the results for the selection in the second step. Because the apps are chained, the results from the first are leveraged in the second.