Overview of fields types
Editable Field Types
Field Type
Display Style
Data Type in Formulas
Notes
AI
text string
Attachment
thumbnails
text string
Attachment URLs displayed in formula results will become invalid
Barcode
text (left aligned)
text string
Use the mobile app to scan barcodes
Checkbox
checkbox w/ icon
varies/other
In formulas can be text (true) or a number (1)
Currency
number (right aligned) w/ symbol
number
Date
date
date/time object
In formulas, date-only fields have a time of GMT midnight.
Date (with Time enabled)
date/time
date/time object
Stored as GMT time.
Duration
duration w/ colons
number
Stored as seconds
Email
text (left aligned)
text string
Linked record
pills w/ primary field values
text string
Restrictions related to allowing multiple records or limiting to a view only apply to direct edits to the field in the interface. When setting values via other methods, these restrictions do not apply.
Long text
text (left aligned)
text string
Long text (with rich text enabled)
formatted text (left aligned)
text string
Formatting is lost in computed fields (lookups/formulas/rollups)
Multiple select
select tokens
varies/other
Sorting is based on the order of the choices, not alphanumeric. In computed fields sometimes acts like an array and sometimes acts like text.
Number
number (right aligned)
number
Percent
number (right aligned) w/ % sign
number
Stored as a decimal
Phone number
text (left aligned)
text string
Auto-formatted in US format when possible
Rating
series of icons
number
Stored as a number
Single line text
text (left aligned)
text string
Single select
select token
text string
Sorting is based on the order of the choices, not alphanumeric.
URL
text (left aligned)
text string
User
user token
text string
Can include Airtable accounts without access to the base
User (w/ allow multiple)
user tokens
Can include Airtable accounts without access to the base
No results from filter
Thank Kuovonne for creating this content!
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.