Formula FX

Formula FX is an AI-powered formula editor. Describe the data transformation you want in plain language, and it generates the expression. Or write formulas directly for precise control.

Type: FORMULA_FX Color: Indigo gradient (#6366F1 → #4338CA) Credits: None Access: Click the wand (✨) icon in the bottom toolbar

What it does

Formula FX takes input from previous nodes and produces a computed output. Think of it as a programmable calculator that can:

Transform text: uppercase, lowercase, trim, replace, split, join
Do math: add, subtract, multiply, divide, round, percentages
Format dates: parse, format, calculate differences
Manipulate arrays: filter, map, sort, flatten, deduplicate
Build JSON: construct objects from variables
Conditional logic: if/then/else expressions

Natural language mode

Type what you want in plain language:

Input	What it generates
"Convert email to lowercase"	`lower({{trigger.body.email}})`
"Calculate 15% of the total"	`{{order.total}} * 0.15`
"Get the first name from full name"	`split({{contact.name}}, " ")[0]`
"Format the date as YYYY-MM-DD"	`formatDate({{record.created_at}}, "YYYY-MM-DD")`
"Combine first and last name with a space"	`{{first_name}} + " " + {{last_name}}`

Direct formula mode

Write expressions directly using FX syntax:

Text functions

Function	Example	Result
`lower(text)`	`lower("HELLO")`	`"hello"`
`upper(text)`	`upper("hello")`	`"HELLO"`
`trim(text)`	`trim(" hi ")`	`"hi"`
`split(text, sep)`	`split("a,b,c", ",")`	`["a","b","c"]`
`join(arr, sep)`	`join(["a","b"], "-")`	`"a-b"`
`replace(text, find, rep)`	`replace("hi world", "world", "there")`	`"hi there"`
`length(text)`	`length("hello")`	`5`

Math functions

Function	Example	Result
`round(num, decimals)`	`round(3.14159, 2)`	`3.14`
`floor(num)`	`floor(3.7)`	`3`
`ceil(num)`	`ceil(3.2)`	`4`
`abs(num)`	`abs(-5)`	`5`
`min(a, b)`	`min(10, 20)`	`10`
`max(a, b)`	`max(10, 20)`	`20`

Transformer vs Formula FX

Feature	Transformer	Formula FX
Input	Visual block editor (drag variables + type text)	Formula syntax or natural language
Best for	Simple string concatenation	Complex transformations, math, conditionals
AI assist	No	Yes (natural language → formula)
Output	String concatenation	Any type (string, number, array, object)

Use Transformer for simple string building. Use Formula FX for anything more complex.

Tip

Start with natural language mode: describe what you want, and FX generates the formula. Then refine the generated formula if needed. It's faster than writing formulas from scratch.

Note

Formula FX is available both as a standalone node (add it from the toolbar's wand icon) and inline within other nodes' FX formula fields (click the fx button on any input field).