Overview

A Function is a relation from a set of inputs to a set of possible outputs where each input is related to exactly one output.


FUNCTIONS

( )

Expressions.

Syntax: ( )

IF

Checks whether a condition is met, and return one value if TRUE, and another value if FALSE

Syntax: IF(logical_test, value_if_true, value_if_false)

IF EMPTY

Checks whether a condition is met, and return one value if TRUE, and another value if FALSE

Syntax: IFempty(value_if_true, value_if_false)

GET

Return the value path of an object or array. To access nested objects, use dot notation. First item in an array is index 1

Syntax: get (object or array, path)

UPDATE

Updates the dictionary with the elements from another dictionary object or from an iterable of key/value pairs

Syntax: update(<source>,<name>,<value>)

OPERATORS

Equals

Is equal to

NOT Equals

Not equal to

AND

Performs a logical conjunction on two expressions

OR

Performs a logical disjunction on two expressions

these operators return true or false
Example:

1 = 1 --> true
1 = 2 --> false

AND operator compare 2 value. if they are similar then true otherwise false
true AND true --> true
true AND false --> false
false AND false --> true
1 AND 1 --> true
1 AND 2 --> false

OR operator check if any value is true. if not found, it will return false
true OR true --> true
true OR false --> true
false OR false --> false

KEYWORDS

True

Logical value(true)

False

Logical value(false)

Updated on: 25/07/2022