Logical

1. ISBLANK

Analyzes the given expression and returns:

  • With one argument: boolean value (true if argument expression does not have a value (is empty or does not exist), otherwise returns false).

  • With 2 arguments: some expression evaluation result or first argument value.

  • With 3 arguments: some expression evaluation result or some other expression evaluation result.

ISBLANK(parameter1) or ISBLANK(parameter1, if_true_parameter2) or ISBLANK(parameter1, if_true_parameter2, if_false_parameter3)

Replace:

parameter1 with logical expression you want to evaluate;

if_true_parameter2 with the result you want to get when parameter1 returns true;

if_false_parameter3 with the result you want to get when parameter1 returns false.

2. NOT

Returns false for TRUE and true for FALSE (inverts result of logical expression).

NOT(parameter)

Replace parameter with a logical expression that you want to evaluate.

3. IF

Determines if condition expression is true or false. Returns a given value if true and another value if false.

IF(condition, result_if_true, result_if_false)

Replace: condition with with the logical expression, result_if_true with the result you want to get if the condition is true, result_if_false with the result you want to get if the condition is false.

4. AND

Returns boolean value: true if all parameter values are true, and false if one or more values are false.

AND(boolean_parameter1, boolean_parameter2, ...)

Replace boolean_parameter1, boolean_parameter2, etc with values or expressions that you want evaluated.

5. OR

Returns boolean value: true if at least one parameter is true, and false if all paramaters are false.

OR(boolean_parameter1, boolean_parameter2, ...)

Replace boolean_parameter1, boolean_parameter2, etc with values or expressions you want evaluated.

6. CASE

Checks given expression value against series of case values. If the expression is equal to one of the case values, returns the corresponding result.

CASE(value, case1, result1, case2, result2, ..., else_result)

Replace:

value with the field or value you want compared to each specified case;

each case (case1, case2, etc.) with the data/expression/field for comparison;

each result (result1, result2, etc.) with data/expression/field that must be returned for the proper case;

else_result with the data/expression/field that must be returned when the expression does not equal to any case.

7. IN

Returns boolean (true or false) result depending on whether checked value is present in given list.

IN(value, list_of_values OR [value1, value2, ...])

Replace:

value with value you need to check in list;

list_of_values with the list to compare value parameter to (or pass list of values as separate parameters value1, value2, etc).

You can also pass combination of lists and separate values as parameters.

8. NOTIN

Returns boolean (true or false) result depending on whether checked value is NOT present in given list.

NOTIN(value, list_of_values OR [value1, value2, ...])

Replace:

value with value you need to check in list;

list_of_values with the list to compare value parameter to (or pass list of values as separate parameters value1, value2, etc).

You can also pass combination of lists and separate values as parameters.

9. INSTANCEOF

Validates if specified value is an instance of a declared type. Returns boolean result (true or false).

INSTANCEOF(value, Decimal|Boolean|String|Date|DateTime)

Replace value argument with a value you want to validate and pass one of the allowed types (Decimal, Boolean, String, Date or DateTime) as second argument.

Last updated