Field Types

Structured tables use field types to make records easier to enter, scan, filter, and connect.

Field type	Use it for
Text	Short names, labels, and single-line values.
Long text	Notes, descriptions, and multi-line content.
Number	Quantities, budgets, counts, and scores.
Currency	Budgets, revenue, expenses, and other money values.
Percent	Progress, rates, conversion, and share values.
Rating	0-5 scores for prioritization, quality, or confidence.
Duration	Time estimates and elapsed work stored as minutes.
Phone	Phone numbers and contact details.
Checkbox	Yes/no or done/not-done states.
Select	One choice from a fixed list.
Multi-select	Several choices from a fixed list.
Date	Calendar dates.
URL	Web links.
Email	Email addresses.
Image	Image URLs or data-image values stored inside the workbook.
Link	A relationship to a record in another table.
Lookup	A displayed value pulled from a linked record.
Grid cell	A reference to a cell in a configured source grid, entered like B2 or B2: Silent Hill 3.
Grid lookup	A displayed value pulled from another column on the same row as a grid-cell reference.
Formula	A calculated value.
Auto number	A read-only row number for records.
Created time	The time the record was created.
Updated time	The time the record was last changed.

Choosing Field Types

Use the narrowest type that matches the job. For example, choose Select instead of Text when a status should always come from the same list, choose Link when a value should point to another table record, and choose Grid cell when a table should point to a cell in a regular grid.

Primary Field

Every table has a primary field. Choose the field that best names the record, such as task name, project name, customer, or asset id. Link fields show records using the related table’s primary field.