trigger search string to select <>'Invalid Region Code!'

[stevelord]

Hi, I've  tried a variety of approaches to get a trigger to select everything in an OfficeCode field except 'Invalid Region Code' short of listing all of the OfficeCodes out.

The trigger is on the Sheet -> OnActivate and I set it as SelectInField, FieldName=OfficeCode, AlternateState = <default state>

Just stuck on the search string to select all but the one value.  I tried using:

not

<>

with a:

wildmatch(OfficeCode, 'Invalid*')

'Invalid Region Code!'

...wonder if select possible, followed by select invalid region code will do it actually..

..just tested that.   It was Select Possible in field OfficeCode followed by a trigger for Toggle Select in field OfficeCode searh string ='Invalid Region Code!'

..so... pretend this was an awesomely short 'howto' blog..  marking assumed answered.

[m_woolf · Accepted solution]

Use 2 actions:

First Select 'Invalid Region Code!

Then

SelectExcluded

[stevelord]

Good flip on the select possible / toggle selection approach I came on while talking to myself.   Thanks!

(This is one of the ones where I tap my forehead and go 'duh'. )