MENU
    Supported field types in Airtable overview
    • 29 Jan 2025
    • 5 Minutes to read
    • Dark
    • PDF

    Supported field types in Airtable overview

    • Dark
    • PDF

    Article summary

    All currently available field types are listed below in alphabetical order. You can check out our API documentation if you'd like more information on the data available for each field type.

    Field type name

    Data type

    Description

    Support article

    Attachment

    File

    An attachment field is a type of field that allows you to attach one or more files directly to your Airtable records. 

    Attachment field type article

    Autonumber

    number

    An autonumber column automatically generates a unique, automatically incremented number for each record. Autonumbers can be helpful when you need a unique identifier for each record, or when using a formula in the primary field.

    Autonumber field type article

    Barcode

    barcode object 

    If you use the mobile Airtable client, then you can use the camera in your mobile device to scan several types of barcodes and QR codes.

    Barcode field type article

    Button

    button object

    The button field adds interactivity to your record such as opening a URL.

    Button field type article

    Checkbox

    boolean

    A checkbox field is useful for true/false values within a record.

    Checkbox field type article

    Count

    number

    A count field lets you count the number of linked records in a record link column.

    Count field type article

    Created time

    string (ISO 8601 formatted date)

    The created time field type will automatically show the date (and optionally, time) that a record was created.

    Created time field type article

    Created By

    collaborator object

    The created by field will automatically show which collaborator created a record within the base.

    Created by field article

    Currency

    number

    A currency field is a specific type of number field that formats the number as a currency amount. 

    Currency field type article

    Date & Time

    string (ISO 8601 formatted date)

    A date field allows you to easily enter a date and optionally a time into a cell. When editing a date time, you will be presented with a calendar widget that makes it easy to select a specific date.

    Date (and time) field type article

    Duration

    number

    The duration field type is a numeric field type intended for use with time durations measured in hours, minutes, seconds, or milliseconds. (If you want to store a time duration measured in days, weeks, or other larger units, use a regular number field.)

    Duration field type article

    Email

    string

    An email field is intended to store a single email address in each cell. Clicking on an email address within an email field will open up your computer's native email client with the To: field addressed to the email you just clicked on.

    N/A


    Formula

    varied outputs (depending on the formula)

    Formulas allow you to compute a value in each record based on other cells in that same record.

    Formula field type article

    Last modified by

    collaborator object

    The last modified by field displays which collaborator made the most recent change to a record. 

    Last modified by field type article

    Last modified time

    string (ISO 8601 formatted date)

    The last modified time field type returns the most recent date and time that a record was modified by a user in a non-computed field 

    Last modified time field type article

    Linked record (Link to another record)

    array of record IDs (strings)

    A linked record field allows you to represent the relationships between related records by creating links between them. This is particularly helpful when you have multiple tables of related items or concepts—for example, if you have a table of contacts and a table of companies, you can use a linked record field to link each contact to the company that they work for.

    Linked Record field type article

    Long text (With or without rich text formatting enabled)

    string

    A long text field is great when you need to keep notes or multiple lines of text in each record. You can enter new lines into a long text field, and even @mention a collaborator inside the text. If you need more styling options, you can enable rich text for the field.

    N/A


    Lookup

    array of numbers, strings, booleans, or objects

    A lookup field allows you to look up a specific field in a linked record.

    Lookup field type article

    Multiple select

    array of strings

    A multiple select field is similar to a single select field; it allows you to select predetermined options from a list. Unlike a single select field, however, you can select as many options as you'd like per cell.

    Multiple select field type article

    Number

    number

    The number field type is a field type designed to hold numbers. The number field type is a general-purpose field type for most numerical values, like the number of chairs of a particular type your furniture business has in stock, or the distance in kilometers from one city to another city.

    Number field type article

    Percent

    number

    The percent field type is a field type designed to hold numerical values formatted as percents. The values in a percent field are all represented as fractions of 100 with the percent sign; e.g. the number .75 in a percent field is represented as 75%.

    Percent field type article

    Phone number

    string

    A phone number field will format a 10-digit string of numbers as a US/Canada phone number, in the form (XXX) XXX-XXXX.

    N/A


    Rating

    number

    The rating field allows you to rate your records for the purposes of ranking or quality assessment.

    Rating field type article

    Rollup

    number or string

    A rollup field performs calculations or formulas on an aggregate of inputs from another field based upon a linked record relationship.

    Rollup field type article

    Single line text

    string

    The single line text field is best for short, unique pieces of text, such as the names of your friends, the names of your cats, or the names of your friends' cats.

    Single line text field type article

    Single select

    string

    A single select field is ideal when you want to be able to select a single option from a preset list of options.

    N/A

    URL

    string

    A URL field is intended to store a single URL in each cell. Clicking on a URL will bring you to that URL.

    N/A

    User

    collaborator object

    The user field allows you to select one or more names from an automatically generated dropdown list of all the collaborators (both workspace collaborators and base collaborators) with whom your base is shared.

    User field type article

    Legacy default values in fields 

    Legacy field values

    Single line text, number, currency, and percent fields in bases created before January 31, 2024, offer the option to toggle on/off "Apply default value for all actions." 

    Any fields displaying "Apply default value for all actions" rely on a legacy default value used inconsistently. You can toggle "Upgrade to consistent default value behavior" on to address the previous inconsistencies. 

    The following scenarios did not use the default value for legacy fields but will after enabling "Upgrade to consistent default value behavior:" 

    • Using the Airtable automation action: Create record without specifying a field value.

    • Using public APIs to create a record without specifying a field value.

    • Submitting a form without a legacy field. 

    • Importing a CSV without specifying field mapping for the related field. 



    Was this article helpful?