Add a formula column
A formula column calculates its value from other columns in the same row: join a first and last name, pull the domain out of a website, turn a score into a tier. You describe it in plain words, Baseloop writes the formula, and you check it on your own rows before saving. Formulas are free.
Add the column
Click Add column at the end of the column headers and choose Formula.
Under Prompt, describe what you want. Type
/and pick a column to use its value, for example "Combine First name and Last name with a space".Click Preview (or press ⌘ Enter). Baseloop writes the formula, names the column, and shows the result on a few rows of your table.
If a result is wrong, change the prompt and preview again. When it looks right, click Save.
How you'll know it worked
The new column fills in for every row at once, with no run and no credits.
From then on, the formula recalculates by itself when a value it reads changes, and on every new row. To recalculate every row yourself, choose Sync from the column's menu. To change it, choose Edit formula.
Ideas
Clean a value: the domain from a website or an email, a name without emojis, a phone number in one format.
Combine values: a full name, a greeting line, a key built from two columns.
Score and route: "High" when employees are over 200 and the industry is Software, otherwise "Low"; a campaign per country and job title.
Gate other columns: use a formula's result in a run condition, so paid columns only run on the rows that pass.
If something goes wrong
The preview shows an error. The message says what went wrong, often a column the prompt names that doesn't exist. Use / to put columns in, so their names are exact.
The formula returns nothing on some rows. The values it reads are empty on those rows. Say what it should return then, for example "or 'Unknown' if the industry is empty".
Can a formula search the web or ask an AI? No. A formula only calculates from the row's own values. For research or judgment, use an AI agent column.