Make the Filter Tool Optional based on Drop Down Value

[S-9]

Hi

I would like to use the action tool to update a filter based on values from the dropdown.  

The dropdown would also have a manual value "All" which if selected, should eliminate the filter tool from filtering anything and pass all records. 

Here is an example: 

Filter by Employee only has two values: Y and N

Add a Manual Text in drop down saying "All"

If "All" is selected, pass records for employees and non employees. 

It does not seem to work when I select All. Any information would help!

Thanks

[TheOC · Accepted solution]

hi @S-9 !

Sorry for the delay in replying to you! This one had me stumped a little bit, but i've found a solution!

I'm sure theres a cleaner solution, but alas:

within my macro:

In a what feels like a hacky way - I am setting the value of each variable they can choose. Here Y and N are clear, but I add the OR conditional within the ALL selection. Wiithin my action:

I have chosen to replace a specific string.


I have attached a packaged workflow with my macro, hope this helps!

[S-9]

that worked great! THANKYOU!