Overview of fields types
Editable Field Types
Editable Field Types
Field Type
Display Style
Data Type in Formulas
Notes
1
AI
text string
2
Attachment
thumbnails
text string
Attachment URLs displayed in formula results will become invalid
3
Barcode
text (left aligned)
text string
Use the mobile app to scan barcodes
4
Checkbox
checkbox w/ icon
varies/other
In formulas can be text (true) or a number (1)
5
Currency
number (right aligned) w/ symbol
number
6
Date
date
date/time object
In formulas, date-only fields have a time of GMT midnight.
7
Date (with Time enabled)
date/time
date/time object
Stored as GMT time.
8
Duration
duration w/ colons
number
Stored as seconds
9
Email
text (left aligned)
text string
10
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.
11
Long text
text (left aligned)
text string
12
Long text (with rich text enabled)
formatted text (left aligned)
text string
Formatting is lost in computed fields (lookups/formulas/rollups)
13
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.
14
Number
number (right aligned)
number
15
Percent
number (right aligned) w/ % sign
number
Stored as a decimal
16
Phone number
text (left aligned)
text string
Auto-formatted in US format when possible
17
Rating
series of icons
number
Stored as a number
18
Single line text
text (left aligned)
text string
19
Single select
select token
text string
Sorting is based on the order of the choices, not alphanumeric.
20
URL
text (left aligned)
text string
21
User
user token
text string
Can include Airtable accounts without access to the base
22
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.