Using Basemind

Fields & formulas

Each column in a table is a field with a type. The type decides what can be stored and how it is displayed, filtered and sorted.

Adding and editing fields

  • Click + at the end of the header to add a field.
  • Click the ▾ next to a field name to rename it, change its type, hide it, sort, filter, duplicate, insert a field left/right, or delete it.
  • Changing a type converts existing values where possible. The conversion can be undone with <kbd>Ctrl/Cmd+Z</kbd>.

Field types

Group Types
Text Single line text, Long text (optionally rich text), URL, Email, Phone number
Numbers Number (decimals, prefix/suffix, thousand separators), Rating, Boolean, Duration, Autonumber
Dates Date (with optional time and timezone), Created on, Last modified
Choices Single select, Multiple select (with colors)
People Collaborator, Created by, Last modified by
Files File (images, documents; previews in the grid)
Relations Link to table, Lookup, Rollup, Count
Computed Formula, UUID, Password
AI AI field (generates a value from a prompt per row, needs an AI provider)

Formulas

A Formula field computes its value from other fields in the same row. Reference a field with field('Name').

field('Price') * field('Quantity')
if(field('Paid'), 'Paid', 'Open')
concat(field('First name'), ' ', field('Last name'))
datetime_format(field('Due'), 'YYYY-MM-DD')
date_diff('dd', field('Created'), now())

Useful groups of functions:

  • Text: concat, upper, lower, trim, left, right, replace, contains, split_part, regex_replace.
  • Numbers: round, floor, ceil, abs, min, max, power, mod.
  • Dates: today, now, date_diff, date_interval, datetime_format, year, month, day.
  • Logic: if, and, or, not, isblank, when_empty.
  • Lists (with link fields): lookup('Link', 'Field'), sum, count, join, filter, avg, min, max.

The formula editor shows every function with a description and an example as you type. Errors are shown before you save.

Lookup, Rollup and Count

After creating a Link to table field:

  • Lookup shows a field of the linked rows, e.g. the company’s country.
  • Rollup aggregates a field of the linked rows, e.g. sum of deal values.
  • Count counts linked rows.

Field descriptions and validation

Every field can have a description (shown as a tooltip on the header). Number fields can be restricted to positive values, date fields to a format, and single selects to their options, which keeps data clean for both people and agents.