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
Solved! Go to Solution.
You'd want to build a macro like the below
IF [#1]="all"
THEN "!IsEmpty([Criteria met])"
ELSE Replace([Destination], "value", [#1])
ENDIF
Example macro attached.