Field types
Each field holds one kind of value. Choose the one that matches what you keep, and views, filters and forms follow.
Text
- Text Field
- A short line: a name, a reference.
- Text Area
- Several lines of plain text.
- Rich Text
- Formatted text, with headings, lists, links and pictures.
- Email, Url, Phone Number
- Checked as you type. A phone number takes any country’s way of writing it.
Numbers
- Number
- Any number, with the decimals you choose.
- Currency
- An amount in the currency you pick, added up in prints and reports.
Choices
- Select
- One choice from a list, each option with its color.
- Radio
- One choice, every option shown at once.
- Select Boxes
- Several choices.
- Checkbox
- Yes or no.
- Tags
- Labels you type freely.
A choice can show as a dropdown, or as a list of every option, each a colored chip.
Dates and times
- Date / Time
- A day and a time.
- Day
- A day alone, written in the workspace’s date format.
- Time
- A time alone.
More
- Barcode
- Text drawn as a barcode, typed, scanned, or worked out from another field.
- Address
- A postal address.
- Color
- A color.
- File
- Pictures, videos, PDFs or any file, each opened large in a gallery.
- Signature
- A signature drawn on screen.
- Formula
- A value worked out from the record’s other fields.
Relations
- Link to records
- Records of another table, or of the same one.
- Lookup
- A field of the linked records, shown here.
- Rollup
- The linked records added up: a count, a sum, an average, the lowest, the highest, or how many differ.
Default values
Most fields can have a default value, given to every new record, from a form or an import too. A date or a time can default to the moment the record is made.