Dynamic listbox with dorpdown field selected by user

Question

Hello,

I want to create a general ledger extraction application in Alteryx Designer.

I'd like the user to be able to select the field they want to filter on using a dropdown list.

And depending on the field selected, the unique values of that field would be displayed in a listbox.

This way, the user can select one or more values and perform their extraction.

I'd also like the user to be able to filter by entering text. (For example, displaying the unique values of the "description" field in the general ledger isn't going to be very clever; they need to be able to search for text.)

I've started to do this, but since I'm a novice, I'm stuck.

Do you have any suggestions for me, please?

Thank you in advance.

App GL Copy.yxwz

apathetichell · Accepted Answer

https://community.alteryx.com/t5/Weekly-Challenges/Challenge-175-Tire-Size-Calculator/m-p/447639

chained apps. In order to have a dynamic listbox you must use chained apps.

jmgross72 · Accepted Answer

Have you used chained apps before?

If you have the user select the filter field in the first app, you can set the second app to run automatically upon a successful run of the first.

Look for this setting in the Interface Designer to chain apps.

This way, the list box in the app will be populated using the user's input from app 1.

You will likely need to use a temporary file in between apps, but you can create a temporary yxdb file to transfer the information to the next chained app.

Unsure about filtering by text, but I hope this helps!