This article demonstrates the use of formula mode in Quickwork Journey Builder.
What you'll need:
Skill level: Easy
Time required: 3 minutes
- Skills to understand the formulas
- Analysis of the formulas written
How to use it
To start using formulas, you need to be in the formula mode. The formula mode needs to be switched on at the field level, and most input fields support the formula mode. To toggle from text mode into formula mode, click on the Test/Formula switch button. This also changes the type icon of the input field into the funnel icon:
Using the formula editor
In formula mode, the formula editor provides a set of whitelisted formulas available for data transformation/manipulation and provides additional help on how to use these formulas.
Whenever you switch an input field to the formula mode and click on it, a list of supported formulas applicable to the input provided:
How do formulas append
Whether it’s a raw input specified or a data pill passed to the input field, formulas get append on a mouse click with a delimiter to the input as a full stop (.). Also, the color of the input characters and the formula chosen changes in order to stand out on the screen:
However, a string as an input if the formula mode has to be in the double-quotes, else error is thrown. In the case of data pills, double-quotes are not required and the color remains unchanged:
A complete list of formulas opens whenever any data pill of any data type is specified as an input. It is necessary to use appropriate formulas for data pills supporting appropriate data types. If a string type data pill is appended with a date type formula, or vice versa, then an error will occur: