Skip to main content

Formula Assist

Formula Assist

Formula Assist is an inline helper inside the Formula node. Describe the value you want in plain language and it writes the expression for you — which you can then read, edit, and keep.

It works on one output field at a time, alongside the field's expression input.

Using it​

  1. Add or select an output field in the Formula node.
  2. Open Formula Assist and describe the value — for example "revenue minus cost as profit", or "the order date formatted as year-month".
  3. Formula Assist inserts a generated expression into the field.
  4. Review and adjust it like any hand-written expression.

It has two modes, chosen automatically:

  • Generate — when the field's expression is empty, it writes one from scratch.
  • Edit — when there's already an expression, it rewrites it to match your new description.

How it stays accurate​

Formula Assist is grounded in the real expression language:

  • It knows every built-in function and the strict-SQL grammar, so it only uses functions that actually exist.
  • It knows which fields are available from the upstream nodes, so it references real columns.
  • Every generated expression is checked before it's inserted — it must parse, use real functions, reference fields that exist, and type-check. If the first attempt fails a check, Formula Assist corrects it once before giving you the best result.

It's authoring help only​

The output of Formula Assist is an ordinary expression string — identical to one you'd type yourself. There is no AI step when your Flow runs; the expression executes exactly like a hand-written one. Formula Assist also never reads your data — it works from field definitions, not from the rows in your sources.

Next steps​