Logical expressions

Logical expressions are Boolean, meaning they return either a value of TRUE or FALSE.

Boolean values won’t display directly on a form. They are used in two situations:

Example fields

Here are some example fields to test out the logical expressions.

There are six comparison operators you can use with logical expressions to compare fields. Some of them can only be used with certain data types.

Name	Symbol	Data types	Expression	Value
Equal to	=	Number, Currency, Date, Datetime¹ Text, User, Boolean	num1 = num2	False
Not equal to	<>, !=	Number, Currency, Date, Datetime Text, User, Boolean	num1 <> num2	True
Less than	<	Number, Currency, Date, Datetime	num1 < num2	False
Less than or equal to	<=	Number, Currency, Date, Datetime	num1 <= num2	False
Greater than	>	Number, Currency, Date, Datetime	num 1 > num2	True
Greater than or equal to	>=	Number, Currency, Date, Datetime	num1 >= num2	True

1. Timezones affect how you compare datetime fields. For example, this expression is true:

Datetime(2018,1,1,12,20,00,"Asia/Kolkata") > Datetime(2018,1,1,12,20,00,"America/Chicago")

Function	Description	Syntax	Value
and	TRUE if both boolean expressions are true. FALSE if either expression is false. Only two parameters are allowed.	AND(num1 = 6, num2 = 4)	True
&&	Same as the AND function, but allows you to use multiple expressions.	num1 = 6 && num2 = 4 && text1 = "Tony"	False
or	TRUE if either boolean expression is true. FALSE if neither expression is true. Only two parameters are allowed.	OR(num1 = 6, num2 = 10)	True
\|\|	Same as the OR function, but allows you to use multiple expressions.	num1 = 6 \|\| num2 = 10 \|\| text1 = "Tony"	True
isBlank	Check if a field is empty (TRUE) or has a value (FALSE). Can be used for any type of field.	isBlank(text1)	False
False	Shows the false boolean.	false()	False
True	Shows the true boolean.	true()	True
Not	Shows the opposite boolean.	Not(num1 = 6)	False