Leaving Airtable? Bring your bases to Artavolo, checked record by record. See how

Field types: which one to use

Updated

A field's type decides what it holds and how you fill it in: text, a date, a choice from a list, a person, a file, a link to another table, or a value worked out for you. Pick the closest type when you add a field, because the type also decides how the field sorts, filters, groups and adds up.

Choose a type

  1. Press the + after the last field, or open Hide fields in the view bar and press Add a field.
  2. Type a Name.
  3. Under Field type, pick a type, or type in Find a type to narrow the list. The line under the list says what the chosen type is for.
  4. Set the type's options and press Create field.

The Add field dialog: a Name box, a Find a type box and the field types Single line text, Long text, Rich text, Attachment, Checkbox, Single select, Multiple select, User, Date, Phone number, Email, URL, Barcode, Button, Checklist and Color

Text

  • Single line text: a name, a title, a short code. See Long text and rich text.
  • Long text: several lines, such as notes, with optional Markdown.
  • Rich text: formatted text with a toolbar.

Choices and people

  • Single select and Multiple select: one or several coloured options from a list. See Single and multiple select.
  • User: one or more people with access to the base. See User field.
  • Checkbox: done or not done, one click to toggle.
  • Checklist: a list of to-dos; the cell shows how many are done.
  • Vote: one click adds your vote or takes it back; the cell shows the count.
  • Color: a colour from the palette or any hex code.

Dates and numbers

  • Date: a day, with or without a time. See Date field.
  • Number: whole numbers, decimals, currency or percent, all in one type. See Number, currency and percent.
  • Duration: a length of time, typed as 1:30 or 1h 30m.
  • Time of day: a clock time with no date, such as 9:30 am or 14:05.
  • Rating: one to ten stars, hearts, thumbs, flags or dots.
  • Sparkline: a list of numbers drawn as a small line, area or column chart.

Files, contact details and codes

  • Attachment: images and files. See Attachments.
  • Phone number, Email and URL: shown as links. See Phone, email and URL.
  • Barcode: a barcode's text, typed or scanned with a phone's camera. See Take photos and scan barcodes.
  • Button: a button on every record that opens a web address built from the record's fields, such as https://example.com/orders/{Order id}.

Computed and automatic

  • Formula: a value worked out from the record's other fields. See Formulas.
  • Created time, Last modified time, Created by and Last modified by: filled in for you.
  • Autonumber: a number every record gets, counting up.
  • AI: a model writes the value from a prompt that names the record's fields. The value is stored and can be edited by hand. It uses your workspace's AI.

Other tables

  • Link to records: records of another table this record points at.
  • Lookup, Rollup and Count: a field of the linked records, a total over them, or how many there are. See Link records between tables.

Good to know

  • Only the base's owners add fields and change their types. Everyone who may edit records fills them in.
  • You can change a type later in Edit field. The dialog says how many values will be cleared or cut short before you save.
  • Currency and percent are formats of the Number type, not separate types.
  • From Airtable, every field type with a match here comes across as that type. A type with no match arrives as a text field, and the import report names it. See Move from Airtable.

Related