Tables & field types — Field types at a glance

• Text — a short, single line of text. • LongText — longer free-form notes. • Number — a plain number. • Currency — a money amount, displayed with money formatting. • Date — a calendar date, displayed in your date format. • Boolean — a yes/no value, shown as a checkmark when on. • Select — one choice from a list you define in Options (comma-separated), shown as a chip. • MultiSelect — several choices from your Options list, shown as multiple chips. • Email — an email address, edited with an email-style input. • Url — a web link. • Phone — a phone number. • Relation — links a record to one or more records in another table (see the next section). • Lookup — shows a value pulled from the record a Relation points to.