Make the Filter Tool Optional based on Drop Down Value

Question

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

employee exp 1.png

employee exp.png

TheOC · Accepted Answer

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!