Formulas

In an you can apply Formulas to extract, format or process your data as they flow in the workflow. It’s as same as working with a spreadsheet software such as MS Excel, where you use formulas (built-in functions)) like sum(…), power(…), concatenate(…) …etc. In the same way, you can use formulas in that performs following functionalities.

• Concatenate first & last name to create full name. e.g. contact({{#firstName}}, {{#lastName}}). Here {{#firstName}} & {{#lastName}} are two macros that resolve into firstName & lastName values that comes from the previous step of your ICApp each time it’s executed.
• When using email as an action, you can add date & time to your email content to specify date(), time() functions.

String Functions

Date Functions

All date & time functions (unless you specify a timezone) uses UTC to avoid any regional differences.

Math Functions

JSON Functions

Other Functions

Regular Expressions Reference

x       The character x
xy      The character x followed by y and so on...
.       Match any single character except newline. When in [] class (see below) it means period.
-       Range in a Character class e.g. [a-z] or [0-9]
[]      Character class. e.g.
            [abc]       a, b, or c (simple class)
            [^abc]      Any character except a, b, or c (negation)
            [a-zA-Z]    a through z or A through Z, inclusive (range)
            [0-9]       0 through 9, inclusive (range)

\       Escape the next character.  e.g. \\ The backslash character
^       The beginning of a line. 
$       The end of a line. 
|       Alternation e.g. x|y  means either x or y.
()      Grouping 
*       0 or more times
+       1 or more times
?       0 or 1 times
{n}     exactly n number of times
{n,}    at least n times
{n,m}   at least n but not more than m times

\d	A digit: [0-9]
\D	A non-digit: [^0-9]
\s	A whitespace character: [\t\n\f\r]
\S	A non-whitespace character: [^\s]
\w	A word character: [a-zA-Z_0-9]
\W	A non-word character: [^\w]