user input filter

[dexter90]

I need to create a user input filter that has following dropdowns

All -display all records

Yes - display only yes

No - display only no

Based on user selection I need filter records.how to create a filter that takes user input and updates the value of filter?

Input file sample

ID     Criteria met

123   yes

321   no

[MichalM · Accepted solution]

@dexter90 

You'd want to build a macro like the below

• Use the Dropdown with manually entered values
• And the Action tool configured to updated the underlying filter with a formula. In this case if user select all you will look for all non-empty values in the Criteria met column and if it's any other value (yes or no) use this to replace the operand in the filter

IF [#1]="all" 
THEN "!IsEmpty([Criteria met])"
ELSE Replace([Destination], "value", [#1])
ENDIF

Example macro attached.