Analytic Apps - Interface Drop Down List

[Analyst323]

Hi,

I am connected to a database where I summarize a list of departments so that they can be picked from a list box. This is then tied to a filter tool which updates automatically. 

I noticed that in order to get a refreshed list, I need to run the workflow at least once. Is there a way to program alteryx to run the first portion of the workflow to update my interface tools and then my end user can proceed to complete the workflow by then sourcing the files in the file browse tool, picking departments, etc via the analytical app tool? I'm afraid that there will be departments missing unless the workflow is ran at least once prior to doing this monthly task. 

[davidskaife]

Hi @Analyst323 

One option is to use Chained Apps, splitting the App into two with the first one running to refresh the lists, which then triggers the next to run automatically using the updated lists.

There is some learning here on Chained Apps - https://community.alteryx.com/t5/Interactive-Lessons/Chaining-Analytic-Apps/ta-p/243120 and also a knowledge base article with examples here - https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Chained-Alteryx-Analytic-Applicatio...

Also a short article on it from The Data School here - https://www.thedataschool.co.uk/brian-scally/chaining-apps-in-alteryx

[ddiesel]

Hi @Analyst323!

I second @davidskaife's suggestion to use a chained app. Let us know if you need any help setting that up.