2 Replies Latest reply: Mar 14, 2018 2:58 PM by Michael Mac Donnell RSS

    Multiple selections for GetFieldSelections in the same field...

    Michael Mac Donnell

      Hi All,

      I am trying to exclude two values in a field when they are selected together. The below works when selected individually but not when selected together. Is there a way to do this? Any help would be appreciated.

       

      Individually works:

      GetFieldSelections([Job Category Desc])<>'Executive' AND GetFieldSelections([Job Category Desc])<>'Senior Management'

       

       

      Failed Attempts to include when both selected:

      GetFieldSelections([Job Category Desc])<>('Senior Management' AND 'Executive')

      GetFieldSelections([Job Category Desc])<>('Senior Management' OR 'Executive')

      GetFieldSelections([Job Category Desc])<>(Senior Management|Executive)