- Is: Checks if the selected field is equal to the set value
- Is Not: Checks if the selected field is not equal to the set value
- Is Empty: Checks if the selected field is empty
- Is Not Empty: Checks if the selected field is not empty
- Contains: Checks if the selected field contains a value in the condition
- Not Contains: Checks if the selected field does not contain a value in the condition
- Contains Any Of: Checks if a field contains any of the selected choices
- Contains All Of: Checks if a field contains all of the selected choices
- Contains None Of: Checks if a field contains none of the selected choices
- Starts With: Checks if the selected field starts with the given value
- Ends With: Checks if the selected field ends with the given value
- Other Choice Is Not Empty: Checks if a value is entered in the Other choice
- Is Any Of: Checks if any of the choices chosen in the condition match
Is None Of: Checks if none of the choices chosen in the condition match
Less Than: Checks if a number is less than a given value
Greater Than: Checks if a number is greater than a given value
Less Than or Equal To: Checks if a number is less than or equal to a given value
Greater Than or Equal To: Checks if a number is greater than or equal to a given value
Between: Checks if a number/date is between 2 given values
Not Between: Checks if a number/date is not between 2 given values
Day Is: Checks if a date falls on the selected day of the week
Day Is Not: Checks if a date does not fall on the selected day of the week
Is Previous Day: Checks if a date falls on the previous day
Is Current Day: Checks if a date falls on the current day
Is Next Day: Checks if a date falls on the next day
Is Before [x] Day(s): Checks if a date falls 'x' number of days before the current date
Is After [x] Day(s): Checks if a date falls 'x' number of days after the current date
Is Previous Week: Checks if a date falls in the previous week
Is Current Week: Checks if a date falls in the current week
Is Next Week: Checks if a date falls in the coming week
Is Previous Month: Checks if a date falls in the last month
Is Current Month: Checks if a date falls in the current month
Is Next Month: Checks if a date falls in the next month
Is Previous Year: Checks if a date falls in the last year
Is Current Year: Checks if a date falls in the current year
Is Next Year: Checks if a date falls in the coming year
Month Is: Checks if a date falls in selected month of the year
Year Is: Checks if a date falls in selected year
Is in the Past: Checks if a date falls in the past
Is in the Future: Checks if a date falls in future
Is Any of Selected Days: Checks if a date falls on any of the selected days of the week
Is None of Selected Days: Checks if a date does not fall on any of the selected days of the week
Is Any of Selected Months: Checks if date falls in any of the selected months of the year
Is None of Selected Months: Checks if date does not fall in any of the selected months of the year
Is Previous Day Before: Checks if the time on the previous day is earlier than a specified time.
Is Previous Day After: Checks if the time on the previous day is later than a specified time.
Is Previous Day Between: Checks if the time on the previous day is within a specified time range.
Is Previous Day Not Between: Checks if the time on the previous day is not within a specified time range.
Is Previous Day At: Checks if the time on the previous day matches a specified time.
Is Previous Day Not At: Checks if the time on the previous day does not match a specified time.
Is Current Day Before: Checks if the time on the current day is earlier than a specified time range.
Is Current Day After: Checks if the time on the current day is later than a specified time range.
Is Current Day Between: Checks if the time on the current day is between a specified time range.
Is Current Day Not Between: Checks if the time on the current day is outside a specified time range.
Is Current Day At: Checks if the time on the current day matches a specified time.
Is Current Day Not At: Checks if the time on the current day does not match a specified time.
Is Next Day Before: Checks if the time on the next day is earlier than a specified time.
Is Next Day After: Checks if the time on the next day is later than a specified time.
Is Next Day Between: Checks if the time on the next day is within a specified time range.
Is Next Day Not Between: Checks if the time on the next day is outside a specified time range.
Is Next Day At: Checks if the time on the next day matches a specified time.
Is Next Day Not At: Checks if the time on the next day does not match a specified time.
Time Is Before: Checks if the time falls before the specified time.
Time Is After: Checks if the time occurs after the specified time.
Time Is Between: Checks if the time falls between two specified times.
Time Is Not Between: Checks if the time is outside the specified time range.
Time Is: Checks if the time matches the specified time.
Time Is Not: Checks if the time does not match the specified time.
True: Checks if logical TRUE value is returned
False: Checks if logical FALSE value is returned
The following table lists the operators that can be used with the corresponding field types to form a rule criteria in the If section: