Function Node

Description

Use the Formula node to create new columns using spreadsheet-like formulas. You reference columns using their name, and formulas are applied automatically to all rows in the table. You have access to arithmetic operations, and a library of functions.

Example 1: Calculate payable tax on your profits

(revenue-cost)*(tax/100)

Example 2: Create full names from first and last names, removing extra whitespace

join(strip(first_name)," ",strip(last_name))

The formula editor will help you write your formulas with:
autocompletion for column names, functions and brackets
syntax highlighting to differentiate numbers, text, columns and functions
error checking (wavy red lines) for mistakes in your formulas

For the full documentation on functions, please reference the Functions References Documentation.

Tips

Functions typically one work for one type of input (e.g. number, text, date & time). We're working on making this more explicit, with better error messages as well.


↩️ Back to Workflow Settings

Updated on: 05/10/2024