I'm trying to use field event triggers to deselect fields based on the value of another field.
It's not working, tho.
Needed Logic: When the UpSegment field is selected, if the only selection is 'K12' then clear the Col_Rep field
On Select, UpSegment, Select in field, Col_Rep
The search string looks like this:
=If(only(UpSegment) = 'K12','', ????? )
what should the else look like (preventing any selection change)? am i doing this right ?
Would it be better to do it with a Macro ? Can someone please provide a macro example for this ?
Thank you in advance !