Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Dynamically update a filter based on user selection

Mina2021
8 - Asteroid

Greetings,

 

I'm currently attempting to build a workflow app that complete the following activities- 

1) User upload a file (*.xlsx file)

2) User to select date range

3) User can select number of action they want to see

4)User can select the view whether it is "forward" or "Backward"

5)User can see by filtering "Inspection Type", "Contents ID" and "Transaction ID"
6)User can see a) Actions, b) both Actions & Date diff

 

So far, I am able to complete till 4) and currently stuck in 5). Does anyone know how we can configure the workflow to allow the filter input tool to be updated based on the options selected by the user? I already did for the Inspection Type but not able to figure out how to do for Contents ID & Transaction ID.

 

Mina2021_0-1616601295201.png

 

 

 

Thanks for all your help!

2 REPLIES 2
Mina2021
8 - Asteroid

Hi there,

 

Any one to help me out? Need urgent resolution actually!

cgoodman3
14 - Magnetar
14 - Magnetar

Hi @Mina2021 

 

You may have already solved this, but in case you haven't or others looking for assistance find your post hopefully the below will help.

 

My biggest tip is to check out the tool examples that are built into Designer, you can get to these by right clicking on a tool and selecting open example:

cgoodman3_0-1619166253709.png

 Within these you can see the different ways the tool can be configured along with the different options for the filter tool. From the screenshot it looks like your best option is to manually configure the fields.

 

In the action tool you want to update the formula with the value selected in the drop down. This is done via the action tool with the following configuration.

cgoodman3_1-1619166643371.png

 

Then when testing the workflow to check it behaves as expected load up the interface designer (View - Interface Designer, if you don't have it on screen already), and click on the magic wand (1). This allows you to replicate how a user would set up the analytic app (2). 

cgoodman3_2-1619166765741.png

Then click on open debug (3), this loads up a new workflow where the filter will have been updated with the value passed from the drop down and allows you to check that it functions as expected.

 

 

 

 

 

 

Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
Labels