Spojit
Formula functions

Transform data inline.
No code step required.

Format a date, clean a string, do the maths, reshape a list, all inline in the field that needs it. A library of formula functions with a live preview, so you reach for code only when you truly need it.

created_at2026-06-16T09:30:00Z
total1480
tags["vip","eu"]
transform
formatDate(created_at, "DD MMM")
16 Jun
total / 100
14.80
join(tags, ", ")
vip, eu
How it works

From raw value to the shape you need

01

Click into any field

Anywhere a value goes, an action input, a mapping, a message, you can switch it to a formula.

02

Insert a function

Pick from date, string, number, and array functions, or nest a few together for the result you want.

03

See the result live

The output updates against real data as you type, so you ship a value you can already see is correct.

Capabilities

A function for every kind of value

Dates and time

Format, parse, add, and compare dates and times across time zones, without wrestling with offsets.

Strings

Trim, split, replace, case, and template text into exactly the shape the next step expects.

Numbers and maths

Round, convert, sum, and calculate, from cents-to-dollars to running totals, inline.

Arrays and lists

Map, join, sort, and pluck fields out of a list to build the value you need from many.

Live preview

Every formula previews against a real record as you write it, so there is no guessing until it runs.

Chain and nest

Compose functions together for richer transforms, while the field stays readable at a glance.

Use cases

Reach for a formula when

Format for an API

Shape a value into the exact format an endpoint expects, like an ISO date or a cents amount.

Build a message

Template a Slack note or an email subject from several fields, no code step in between.

Clean messy input

Trim whitespace, normalize casing, and standardize values before they flow downstream.

Summarize a list

Join, count, or total the items in a collection into a single value for the next action.

The difference

Formulas vs a code step for everything

Keep the everyday transforms inline and readable, and save code for the genuinely complex logic.

Use a formula when

  • The transform is a date, string, number, or list tweak
  • You want to preview the result before it runs
  • Non-engineers need to read and change it later

A code step for every tweak means

  • A whole sandbox to format one date
  • More code to review and maintain
  • Only the author can safely change it

Transform data without code

Start free and reshape a value with a formula and a live preview. No card needed.