Hi! Having searched and search, I cannot find a way to setup a single step button action that would select all but one value in a field.
Example:
[Field 1]
a 1
b
...
z
Desired behavoir is to select all values except 'a 1'. I can use my button action to set the field 1 value to 'a 1', then use a second buton action to select excluded values for field 1. This is a decent solution, but it feels like there has to be a one-step solution.
I've tried "select values matching search criteria" with the expression:
=`=[Field 1]<>'a 1'`
But it doesn't work. Maybe it's because the expression string has embedded single quote characters? Or maybe <> isn't supported.
Ideas? Thanks in advance
