This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Our company often builds applications where we need the ability for it to dynamically update dropdowns based on a user's previous selections.
A user needs to select their Server, database, and table for analysis (3 dropdowns).
When the user selects their server, a query is run to get a list of all databases on that server. Then the database dropdown will automatically populate with this list of databases.
The user then makes a database selection, and a query is then run to get all tables within that database. The table dropdown will automatically populate with this list of tables.
The user makes their table selection, and then runs their analysis using the server, database, and table variables with values that they have selected from each dropdown.
We can do this in other programs, but unfortunately the lack of dynamic selections/dependent dropdowns is a big limitation for us when building Alteryx applications. Our current workarounds are chaining applications together, or using PyQt within the workflow. Chaining is clunky and often causes unforeseen issues when uploading to Server with errors that are non-descriptive, and using PyQt comes with Python versioning issues.
If this interactivity can somehow be added to Alteryx applications it would be a huge upgrade to our current Alteryx processes. Any suggestions for further workarounds would also be helpful!