Functions

A function name is given in capital letters and is followed by a parenthesis. Arguments are given within the parenthesis, separated by commas.

For example:

OLD (STAI)
ISBLANK (TRIM (CORI))
SUBSTRING (PARM, 1,2)

This table shows the available functions and their descriptions:


Functions	Description
ISBLANK(field)	Returns true if the field is empty; otherwise, the value returned is false.
ISCHANGED(field)	Returns true if the field has a different value than its old value; otherwise the value returned is false. This function can only be used for received events with the Update operation.
OLD(field)	Returns the old value of the field. This function can only be used for received events with the Update operation.
SUBSTRING(string, beginIndex, endIndex)	Returns a substring of the string. The attribute `beginIndex` is zero-based and inclusive. The attribute `endIndex` is zero-based and exclusive. For example, to extract 'CD' from the string 'ABCDE', use beginIndex = 2 and endIndex = 4.
TOUPPER(string)	Converts all characters in the string to uppercase.
TOLOWER(string)	Converts all characters in the string to lowercase.
TRIM(string)	Removes leading and trailing white space from the string.