Macro Dynamic Drop Down

Hi,

I am designing a macro that has a drop down question which gets populated from a database table. The trouble I have is that the macro seems to cache the database entries from the last time I open the macro, run and safe it. I know it's possible, as for example the "Salesforce Input" tool does exactly that. you enter your credentials, hit Connect and it fetches all available objects to choose from. If I add an object in Salesforce and go back into the Alteryx tool, it automatically refreshes the drop down list and the new object is there.

Any hints much appreciated...

Thanks

Peter

Macros

Accepted answers

ChrisTX

See the comment from DanM on this page:

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Tool-Mastery-Drop-Down/ta-p/37094

...create a chained workflow. The first workflow would update an output, which in turn you would use that output to update the Drop Down

pgosztonyi

Thanks, I stumbled across a Youtube video which in essence explained the same thing. the issue was indeed that I populated the drop down tool with a data flow within the same macro - this didn't run until the macro ran.

I didn't need a second workflow though to fix it. As all data is in a database, I just had to change the drop down tool to use an external source and used a select statement as the external source. Now the drop down tool has no dependency on any other tools.

Peter

All comments

ChrisTX

See the comment from DanM on this page:

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Tool-Mastery-Drop-Down/ta-p/37094

...create a chained workflow. The first workflow would update an output, which in turn you would use that output to update the Drop Down

pgosztonyi

Peter

pgosztonyi

Just to take it one step further. In the Salesforce tool I can select an object which then populates a list box with the columns. Would you know how to populate a second drop down tool based on the selection in the first tool?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703