If statement in search string of select in field action
I would like to use an if statement in the search string of a select in field action. The selection works without the if statement. Once I try to add the if statement in it no longer works.
If I put this in a text box it gives me the correct answer. If I put this in a search string of a select in field action, it does nothing. I'm sure the issue is the syntax for the search. I just don't know what the correct syntax is or if it can be done at all.
