Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

latest drop down value not display unless running the workflow

Highlighted
8 - Asteroid

Hi

 

I got an app which take values from an sql table for one of the drop down. If we enter a new value into the sql table how can i refresh the workflow without running the workflow to take the latest value from the table to display in the drop down? is there a way to refresh the drop down menu as soon as the app is open?

 

app screen shot.PNG

 

Screen shot above is of the drop down and the how the values are coming into the drop down

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

@AndrewCrayford you shouldn't really have any transformation tools connecting to the drop down.

 

You need to check out 'chained apps' and how they allow you to achieve this.

 

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Chained-Alteryx-Analytic-Applications/ta-p/7...

 

Essentially you have workflow A which takes your table and converts it into the format needed for the drop down, you would right this resulting table, somewhere on your machine or into a database.

 

Your second piece then has everything else, with your drop down connected directly to the database you have written in the previous piece. 

You can then chain them together so when the user hits 'run' it will run the first part (which requires no user config). They will then be presented with the latest drop down values.

 

Ben

Labels