Field Event Trigger

[BarbCline]

I have a field event trigger to test the value of a field (OnSelect) and set a variable accordingly.  This works great in most scenarios; however, if I have any other field selected, the clearing of the first field does not fire the trigger.

Here's my expression: =if(GetFieldSelections([Case Size]) = '51-99', 'Y', 'N')

When I select or clear Case Size, the trigger fires and sets the variable appropriately.  But, if I have any other field selected along with Case Size, when I clear Case Size, the trigger never fires.

Any ideas on how to fix this?

[Jason_Michaelides · Accepted solution]

I think it's because [Case Size] is not actually being selected.  Instead of using a trigger and GetFieldSelections([Case Size]) try just creating a variable with the expression =if(Only([Case Size]) = '51-99', 'Y', 'N')

Hope this helps,

Jason

[BarbCline]

Excellent!  That's works perfectly ... and so easy   Thanks for sharing, Jason!