Select in Field Action on Text Object

[#1]

How do I perform a NOT select in field action on a text object.  When someone selects a text object ("button"), I want all values of a field selected except for one.  I tried the "select excluded" but not too sure how that was all working.

For example, field name [fruit type] and I want everything but "apples". 

[Anonymous · Accepted solution]

Try two actions:
1. Select in filed "fruit type", value 'apples'

2. Select Excluded in "fruit type"

[#3]

That worked, thanks.

Can you quickly explain to me the logic behind the "Select Excluded" action?

[Anonymous]

It inverses the field selections.  That is, all values items in gray will be selected, and what was selected becomes excluded.  So in your example, you select 'apples'.  Next, you select anything except 'apples'.

[#5]

thanks! makes sense