Dependent Dropdown

[swapsingh2712]

I'm trying to create an app where you select a manager from a drop down, and depending on which manager you choose, it shows the list of people reporting to him. For example, if I select any manager like Jon Doe from the manager drop down, the next drop down will only show the list of associates that reports to him. The data will be coming from the database.

This app will basically assign the number of assets assign to the associates which would be a numeric up down.

Also I'm trying to add functionality where user can see all the data that are entered in the table along with the option to update the entry if he/she entered incorrect data

Please advise.

[clmc9601]

Hi @swapsingh2712,

Would a Tree tool accomplish what you want? It's probably easiest to see from the sample workflows explained in the link.

You could build a view in the database that stores the specific tree layout, or you could schedule a workflow to refresh the tree file every once in a while to check for new folks.

If this helps, please consider marking it a solution so others may find it.

[swapsingh2712]

Hello @clmc9601 

Thank you for your response.

Is there any other way apart from tree tool which I can use?

[clmc9601]

Hi @swapsingh2712,

The only other option I can think of is to build a chained app. Here are some ideas. Alteryx interface tools execute all at once. So if you want them to go sequentially, you have to use some sort of workaround.

[PeterA1]

Hi @swapsingh2712 I would agree with the point that a chained application may be the best method here! If you want an example of one you can take a look at this weekly challenge from a while back which creates a tire size calculator where the user has different drop downs based on their prior choice. This should at least give you a template to build yours on. In fact, the solution file probably can be downloaded so you can take a look. 

[MatthewBr]

You can create an analytic app to populate and filter the manager you need. See the Analytic App that I set up with Begin and End Dates.  You can follow that model.  Let me know if that works for you.  If need be I can help you further.