Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Id like to make a single button that searches 4 fields. It will need to look at the 4 fields and find anywhere that it says "Yes". I did this already by making a button with 4 "Select in field" actions and have each be 1 of my fields and search string = *Yes*.
This does not meet the requirement though. This will find only rows that have "Yes" in all 4 fields, not just finding the rows that could have "Yes" in one of the fields. If someone has a suggestion that would be great!
Thanks!
I would suggest creating a new field with a hidden prefix in your script. Then you use a select in field action based on that field instead of your four fields. See attached.