Skip to main content
A function column transforms data you already have: joining two columns, pulling keywords out of text, scoring a list. It never calls an outside source, so it costs nothing and runs in a moment.
The Tools panel docked beside a table on its Functions tab, listing HTTP API, HTTP API with JWT, Resolve hostname, Formula, Merge columns, Find keywords, Filter list, Sort list, Common values, Text similarity, Detect language, Score words and Hash value, each with a one-line description.

The Tools panel, open on the Functions tab.

​
Add a function column

1

Open the Functions tab

Click Tools above the grid, then the Functions tab. It is a flat list, not shelves.
2

Pick a function

Click Formula to build your own, or a named one like Merge columns or Find keywords to start from it.
3

Describe it, or build it by hand

Type what the column should compute and click Generate, or click Set up manually to assemble the steps yourself.
4

Check the preview

Each step picks a Function and a source column. The preview fills in as you edit, so you see real values before you commit.
5

Create the column

Click Create. It runs over every row straight away.
Function columns are free. Only enrichment and agent columns spend credits, so nothing here shows a price.

​
What you can compute

Formula chains steps together for anything custom. The named functions cover the common jobs. Text and lists: Merge columns, Find keywords, Filter list, Sort list, Common values, Text similarity, Detect language, Score words. Values and routing: Hash value, URL-encode, Is URL valid, Email permutations, Round-robin assign, Weighted round-robin assign. HTTP API and HTTP API with JWT call your own endpoint once per row. Resolve hostname checks a domain answers before you spend on it.

​
Good to know

Every function opens the same editor. Formula starts blank; a named function starts with its own steps already in place, which you can then change.
Once you have hand-edited the steps, asking the assistant to generate again warns you before it replaces your work.
Ask for something a function column cannot do, such as looking a fact up on the web, and the assistant says so rather than guessing. That is a job for an enrichment column or an agent column.
There is no preview button. The sample recomputes as you change a step, and an empty preview usually means a source column is empty rather than that the formula is wrong.
Create and don’t run, beside Create, saves the column and leaves its cells empty until you run it.
A row whose inputs do not suit the function shows an error in that cell, and the rest of the column still fills. Run conditions work here too, and without the usual cost warning, because there is no cost.

​
Next steps

Enrichment columns

Pull facts from outside sources instead.

Run columns

Decide when a column fills its cells.