Function |
Name |
Description |
STRING-LENGTH(val) |
Length | |
SUBSTR(val, startIndex, lengthOptional) |
Substring | Retrieves a substring from the given value. Substrings start at the zero-indexed start position and run to the end of the val unless an optional character length is specified. e.g. if myfield has value ‘ABCDEF’, then: SUBSTR({{myfield}}, 2) gives CDEF SUBSTR({{myfield}}, 2, 1) gives C Substring |
CONCAT(val1, val2, val3) |
Concatenate | |
JOIN('separator', val1, val2) |
Join | Concatenate With Separator |
SUBSTITUTE(val, old text, new text) |
Substitute | Substitutes new text for old text into the given value. e.g. if myfield has value ‘ABC|DEF’, then: SUBSTITUTE({{myfield}}, ‘|’, ‘\n’) replaces | with new line |
LOWER(val) |
Lower Case | Converts all characters in the specified val to lower case e.g. LOWER({{myfield}}) |
UPPER(val) |
Upper Case | Converts all characters in the specified val to upper case e.g. UPPER({{myfield}}) |
RANDOMSTR(length) |
Random String | Generates a random string of characters of the given length |
GUID() |
GUID | Generates a new ‘http://en.wikipedia.org/wiki/Globally_unique_identifier’ Globally Unique Identifier |
Text based Functions
Create a Formula. sin(). Excel Financial Functions. tan(). Data Conversion. number(). int(). boolean(). string(). Generate a Unique ID Code. logarithm(). random(). Template Functions. imgurl(). utcnow(). cosh(). sinh(). userlastname(). now(). useremail().