Skip to content

Field types

The type you give a field decides what its column can hold and how it behaves: a date field shows a calendar, a money field carries a currency, a dropdown only accepts choices from your list. Picking the right type up front keeps your data clean and makes filtering and sorting work the way you’d expect. Here’s the full menu.

The types

Type	Holds	Reach for it when…
Text	Words — single-line or multi-line	…you need names, notes, descriptions, links.
Integer	Whole numbers	…you’re counting things: quantity, headcount, priority.
Float	Decimal numbers	…you need fractions: weight, hours, a rating.
Boolean	True / false	…it’s a simple yes/no: “Contacted?”, “In stock?”.
Date	A calendar date	…only the day matters: due date, start date.
DateTime	A date and time	…the time of day matters: a meeting, a deadline.
Money	An amount with a currency	…you’re tracking value: deal size, price, budget.
Enum	One choice from a fixed list	…there’s a set of options: Stage, Status, Category.
Attachment	One or more files	…rows carry documents, images, or contracts.

Field properties

Beyond its type, every field has a few settings:

Property	What it does
Name	The column label everyone sees.
Description	Optional note explaining what the field is for.
Required	When on, an entry can’t be saved with this field empty.
Array	When on, the cell can hold multiple values (several files, several tags).
Position	Where the column sits, left to right. Drag to reorder.

A worked example

A simple “Sales Leads” database might use:

Company        → Text (required)
Contact email  → Text
Stage          → Enum (New, Contacted, Demo, Won, Lost)
Deal size      → Money (USD)
Next step on   → Date
Documents      → Attachment (array)

Clean types here mean you can later filter to Stage = Demo, sort by Deal size, and never wrestle with inconsistent data.