Data field types

A Data table column is one of these. The type decides what a cell can hold, how it sorts, and whether it can be typed into at all.

29 field types

Typed in

You enter the value · 18

Text

text

A single line. The default for anything short.

Long text

long_text

Several lines, for notes.

Number

number

A plain number.

Currency

currency

Money. Stored in pence and shown in pounds, so a total never drifts by rounding.

Percent

percent

A percentage.

Date

date

A date, with an optional time.

Checkbox

checkbox

Ticked or not.

Single select

single_select

One choice from a list you define, each with its own colour.

Multi select

multi_select

Any number of choices from that list.

Email

email

An address, shown as a mail link.

URL

url

A link.

Phone

phone

A number, shown as a dial link.

Link to records

relation

A link to rows in another table in this workspace.

Lead

lead

A link to a real lead. Not the name typed as text — the record, so the row travels with them.

User

user

A member of your team.

Rating

rating

Stars, out of five.

Duration

duration

A length of time.

Barcode

barcode

A code, rendered so a scanner can read it.

Worked out

Computed from the row or through a link — never typed into · 9

Rollup (read through a link)

rollup

A number rolled up from linked rows — their total, average, highest or lowest.

Created time

created_time

When the row was made.

Last modified time

last_modified_time

When it last changed.

Autonumber

autonumber

A number given out in order, never reused.

Count

count

How many rows are linked.

Lookup

lookup

A value copied through a link, so it shows here and lives there.

Formula

formula

Worked out from other fields in the same row.

Created by

created_by

Who made it.

Last modified by

last_modified_by

Who last changed it.

Neither

A control or a file, rather than a value · 2

Button

button

Opens a link built from the row. Never stores a value.

Attachment

attachment

Files. The cell holds references; the files live in private storage.

This page is generated from the same list the product runs on, so it is never out of date. Something missing or unclear? Get help.