Skip to content
Kuovonne's Guide to Airtable
  • Pages
    • Kuovonne's Guide to Airtable
      • Fields
        • Overview of fields types
          • icon picker
            Editable Field Types
          • Computed Field Types
          • Field Types by Formula Data Type
          • Field Types in Scripting
        • Specific field types
          • Formula fields
            • Demystifying Formulas (DareTable 2022)
          • Rollup fields
          • Select fields
          • Attachment fields
            • Uploading Attachments
            • Attachment Size
            • Attachment URLS
            • Thumbnails
        • Converting Field Types
        • Naming fields
        • Metadata fields
          • Simple Metadata Fields
          • Data Validation
          • Additional Dependencies
          • Original Record URL (Thumbprint) Field
          • Column Divider Fields
          • DareTable 2023 Presentation
        • Field dependencies
      • Formulas
        • Formula Field Reference
        • Writing Formulas
          • Using AI to Write Formulas
          • General tips for writing formulas
          • Testing for Blank Values
          • Drafting Formulas in Parts
          • Function versus Operator
          • Typing Special Characters
          • Commenting Formulas
          • Formulas to avoid
        • Formatting Formulas
          • Basic Rules
          • Nested IF formulas
          • SWITCH Formulas
          • Operators
        • Specific Formulas
          • Ranges of Numbers Values
          • Comma Separated List of Fields Values with Optional Fields
          • Earliest / latest date across columns
          • List Fields Values (one per line) with Optional Fields
          • Rounding a date to the half year
          • Url of Interface Page for a record
          • Removing varying items from a list
        • Data Type Conversion in Formulas
          • Text to Numbers
          • Numbers to Text
          • Data type conversions with Dates
        • Troubleshooting Formulas
          • Formulas that won't save
          • Hiding or showing #ERROR!
          • Troubleshooting date/time/duration formulas
          • Troubleshooting numeric formulas
          • Troubleshooting formulas with lookups
          • Troubleshooting text formulas
      • Automations
        • Triggering automations
          • Triggering automations for typed values
          • Triggering automations on existing records
        • Sending Emails
          • Ways to send emails
          • Using links in emails
          • Emailing Attachments
        • Accessing updated record values
        • Third party automations
        • Managing automation runs
      • Templates
        • Templates for record values
        • Templates using field values
      • Controlling Access
        • Sharing a base
        • Access control considerations
        • Techniques for limited access
          • Airtable interface
          • Share link access
          • Synced table
          • Prefilled forms + Automations
          • 3rd party portal
          • 3rd party webhook
        • Preventing base duplication
      • Specific Solutions
        • Most recent form submission for ermail
        • Email digest of a person’s records
        • Sum of Multiple Select choices
        • Link to multiple records based on select choices
        • Dropping Lowest Score (top 4 of 5)
        • Identify the position of a record in a linked record field (top 4 of 6)
        • Sequential Numbering of Records
        • Ending a list of rollup items with ", and"
        • Table ID in a formula
        • Latest/earliest date across several fields
        • Associating People with Records
        • First Tuesday of the Previous Month
      • Miscellaneous
        • Web API Calls for External Integrations
        • Getting paid to work with Airtable
        • Hiring a consultant
        • Airtable Communities
        • Making major changes to a base
      • Suggestion for this guide
Kuovonne's Guide to Airtable
/
/
Editable Field Types
Share
Explore

Editable Field Types

⁠
⁠
Tip Jar
⁠
Thank Kuovonne for creating this content!
⁠
⁠
⁠
⁠
⁠
Field Type
Display Style
Data Type in Formulas
Notes
AI
​

Attachment
thumbnails
Attachment URLs displayed in formula results will become invalid
Barcode
text (left aligned)
Use the mobile app to scan barcodes
Checkbox
checkbox w/ icon
In formulas can be text (true) or a number (1)
Currency
number (right aligned) w/ symbol

Date
date
In formulas, date-only fields have a time of GMT midnight.
Date (with Time enabled)
date/time
Stored as GMT time.
Duration
duration w/ colons
Stored as seconds
Email
text (left aligned)

Linked record
pills w/ primary field values
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)

Long text (with rich text enabled)
formatted text (left aligned)
Formatting is lost in computed fields (lookups/formulas/rollups)
Multiple select
select tokens
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)

Percent
number (right aligned) w/ % sign
Stored as a decimal
Phone number
text (left aligned)
Auto-formatted in US format when possible
Rating
series of icons
Stored as a number
Single line text
text (left aligned)

Single select
select token
Sorting is based on the order of the choices, not alphanumeric.
URL
text (left aligned)

User
user token
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.
Try clicking the ··· in the right corner or using a keyboard shortcut (
CtrlP
) instead.