Calculations and comparisons

Create steps in your workflow that allow calculations and comparing data.

Calculating formulas

This operation allows you to carry out arithmetic operations.

In your workflow editor, click + Add step.
Select Integrations > Quick action.
Click Configure.
Click the Quick Action operation field and select Calculate formula.
Enter your formula.
Tip: you can include numbers, text, operators, and data references (the values in input fields from previous steps)

If you want to use the comparison result in later steps add the result variable in the Response data for use in later steps. The variable's value should be $.result

Comparing formulas

In your workflow editor, click + Add step.
Select Integrations > Quick action.
Click Configure.
Click the Quick Action operation field and select Compare formula.
Enter your formula.
Tip: you can include numbers, brackets, operators, and data references (the values in input fields from previous steps)

Supported operations

Calculating formulas


-	add	1+1 = 2
-	subtract	4-2 = 2
/	divide	4/2 = 2
-	multiply	2*2 = 4
**	exponents (to the power of)	3**2 = 9
%	remainder (amount left over)	5%2 =

Comparing data

Operator	Description	Expression example	Result
`==`	equals	`2==2`	True
`<`	less	`1<2`	True
`>`	greater	`1>2` `{1. New form - Date Input - Date (plain)} (%s) > {Instance start time} (%s)`	False True (used to compare dates)
`<=`	less than or equal to	`2<=2`	True
`> =`	greater than or equal to	`1>=2`	False
`endswith`	Looks for text ending with a provided phrase; comparing ends of strings	`endswith(".txt", "text.txt")` `endswith(".txt", "{{data_reference_to_filename}}")`	returns `True` if the string ends with the specified suffix, otherwise `False`.
`startswith`	Looks for text starting with a provided phrase; comparing the beginnings of strings	`startswith("pata", "patata")` `startswith("pata", "{{data_reference_to_filename}}")`	returns `True` if the string starts with the specified suffix, otherwise `False`.
`in`	Checks if a value exists within a sequence Note that list evaluations such as `1 in [1,2,3]` are not supported using `in` and `not in` operators.	`"ana" in "banana"`	True
`and`	boolean operator; Use to combine multiple comparison expressions when you need all conditions to be true.	`("monday"=="monday") and 2>1`	True
`or`	boolean operator; When using `or`, the combined condition evaluates to `True` if at least one of the individual conditions is True. If all conditions are `False`, the combined condition will evaluate to `False`.	`("{{data_reference_to_fruit}}") == ("apple") or ("{{data_reference_to_fruit}}") == ("banana") or ("{{data_reference_to_fruit}}") == ("cherry")`	True

Comparing regular expressions

Regex example	Description	Result
`match_regex('\\d{3}-\\d{2}-\\d{4}', '123-45-6789')`	Checks whether the string matches a specific regular expression pattern	True
`match_regex('\\d{3}-\\d{2}-\\d{4}', '45-6789')`	Checks whether the string matches a specific regular expression pattern	False
`match_regex('te.\*st', 'tessssst')`	Checks whether the string matches a specific regular expression pattern	True
`match_regex('te.+st', 'test')`	Checks whether the string matches a specific regular expression pattern	False
`match_regex("((([A-Za-z]{3,9}:(?:\/\/)?)(?:[-;:&=\+\$,\w]+@)?[A-Za-z0-9.-]+\|(?:www.\|[-;:&=\+\$,\w]+@)[A-Za-z0-9.-]+)((?:\/\[\+~%\/.\\w-_]_)?\??(?:\[-\+=&;%@.\\w_]\_)#?(?:[.\!\/\\w]\*))?)", "[www.url-with-querystring.com/?url=has-querystring"](http://www.url-with-querystring.com/?url=has-querystring")`	Checks if the string contains a URL that matches the pattern defined by the regular expression.	True
`match_regex("((([A-Za-z]{3,9}:(?:\/\/)?)(?:[-;:&=\+\$,\w]+@)?[A-Za-z0-9.-]+\|(?:www.\|[-;:&=\+\$,\w]+@)[A-Za-z0-9.-]+)((?:\/\[\+~%\/.\\w-_]_)?\??(?:\[-\+=&;%@.\\w_]\_)#?(?:[.\!\/\\w]\*))?)", "not_valid.url-with-querystring.com/?url=has-querystring")`	Checks if the string contains a URL that matches the pattern defined by the regular expression.	False

📘
For limitations in the supported regular expressions, see Syntax (external page).
You can use this external page to test if your expression is correct.

Updated 3 months ago