Expression Editor Operators

Table 1-10: Expression Editor Operators
Operator	Description
is	Applicable to Date, Time, and User field types.
is not	Applicable to Date, Time, and User field types.
is after	Applicable to Date and Time field types.
is on or after	Applicable to Date and Time field types.
is before	Applicable to Date and Time field types.
is on or before	Applicable to Date and Time field types.
begins with	Applicable to Text, Multi-line Text, Pick list, and Multi-pick list field types.
does not begin with	Applicable to Text, Multi-line Text, Pick list, and Multi-pick list field types.
is between	Applicable to Number, Date, and Time field types. Note: Not available for responsive forms.
is not between	Applicable to Number, Date, and Time field types. Note: Not available for responsive forms.
contains	Applicable to Text and Multi-line Text field types.
does not contain	Applicable to Text and Multi-line Text field types.
is current user	Applicable to User field type only.
is not current user	Applicable to User field type only.
is current user’s	Applicable to Text and Pick list field types.
is during the current	Applicable to Date and Time field types. Note: Not available for responsive forms.
is during the last	Applicable to Date and Time field types. Note: Not available for responsive forms.
is during the next	Applicable to Date and Time field types. Note: Not available for responsive forms.
is empty	Applicable to all field types except check boxes (Boolean).
is not empty	Applicable to all field types except check boxes (Boolean).
ends with	Applicable to Text, Multi-line text, Pick list, and Multi-pick list field types.
does not end with	Applicable to Text, Multi-line text, Pick list, and Multi-pick list field types.
equals	Applicable to Number, Text, Pick list, Multi-pick list, and Boolean field types.
does not equal	Applicable to Number, Text, Pick list, Multi-pick list, and Boolean field types.
is greater than	Applicable to Number, Text (alphabetical order), Pick list, and Multi-pick list field types.
is greater than or equal to	Applicable to Number, Text (alphabetical order), Pick list, and Multi-pick list field types.
is less than	Applicable to Number, Text (alphabetical order), Pick list, and Multi-pick list field types.
is less than or equal to	Applicable to Number, Text (alphabetical order), Pick list, and Multi-pick list field types.
is one of	Applicable to Text, Pick list, Multi-pick list, and User field types. Reduces the number of OR connector statements listed when creating multiple statements that search for values of the same field type. The “is one of” operator helps reduce the use of the “OR” connector group in complex expressions to avoid having to scroll down the screen to see the entire expression. See ‘Is One of’ Operator.
is not one of	Applicable to Text, Pick list, Multi-pick list, and User field types. Reduces the number of OR connector statements listed when creating multiple statements that search for values of the same field type. The “is not one of” operator helps reduce the use of the “OR” connector group in complex expressions to avoid having to scroll down the screen to see the entire expression. See ‘Is One of’ Operator.

is

Applicable to Date, Time, and User field types.

is not

Applicable to Date, Time, and User field types.

is after

Applicable to Date and Time field types.

is on or after

Applicable to Date and Time field types.

is before

Applicable to Date and Time field types.

is on or before

Applicable to Date and Time field types.

begins with

Applicable to Text, Multi-line Text, Pick list, and Multi-pick list field types.

does not begin with

Applicable to Text, Multi-line Text, Pick list, and Multi-pick list field types.

is between

Applicable to Number, Date, and Time field types.

Note: Not available for responsive forms.

is not between

Applicable to Number, Date, and Time field types.

Note: Not available for responsive forms.

contains

Applicable to Text and Multi-line Text field types.

does not contain

Applicable to Text and Multi-line Text field types.

is current user

Applicable to User field type only.

is not current user

Applicable to User field type only.

is current user’s

Applicable to Text and Pick list field types.

is during the current

Applicable to Date and Time field types.

Note: Not available for responsive forms.

is during the last

Applicable to Date and Time field types.

Note: Not available for responsive forms.

is during the next

Applicable to Date and Time field types.

Note: Not available for responsive forms.

is empty

Applicable to all field types except check boxes (Boolean).

is not empty

Applicable to all field types except check boxes (Boolean).

ends with

Applicable to Text, Multi-line text, Pick list, and Multi-pick list field types.

does not end with

Applicable to Text, Multi-line text, Pick list, and Multi-pick list field types.

equals

Applicable to Number, Text, Pick list, Multi-pick list, and Boolean field types.

does not equal

Applicable to Number, Text, Pick list, Multi-pick list, and Boolean field types.

is greater than

Applicable to Number, Text (alphabetical order), Pick list, and Multi-pick list field types.

is greater than or equal to

Applicable to Number, Text (alphabetical order), Pick list, and Multi-pick list field types.

is less than

Applicable to Number, Text (alphabetical order), Pick list, and Multi-pick list field types.

is less than or equal to

Applicable to Number, Text (alphabetical order), Pick list, and Multi-pick list field types.

is one of

Applicable to Text, Pick list, Multi-pick list, and User field types. Reduces the number of OR connector statements listed when creating multiple statements that search for values of the same field type.

The “is one of” operator helps reduce the use of the “OR” connector group in complex expressions to avoid having to scroll down the screen to see the entire expression. See ‘Is One of’ Operator.

is not one of

Applicable to Text, Pick list, Multi-pick list, and User field types. Reduces the number of OR connector statements listed when creating multiple statements that search for values of the same field type.

The “is not one of” operator helps reduce the use of the “OR” connector group in complex expressions to avoid having to scroll down the screen to see the entire expression. See ‘Is One of’ Operator.