- Getting started with Airtable
- Introduction to Airtable basics
- Contacting Airtable Support Updated
- Airtable home screen
- Glossary of Airtable terminology
- Airtable technical requirements
- Feature differences between Airtable on desktop and mobile
- Airtable keyboard shortcuts
- Using Markdown in Airtable
- Adding descriptions in Airtable
- Finding Airtable IDs
- Airtable Automations
- Automations Overview
- Automation feature walkthroughs
- Integrated automation walkthroughs
- Airtable automation walkthroughs
- Linking existing records using automations
- Conditional groups of automation actions
- Repeating groups of Airtable automation actions
- Creating recurring records using automations
- How to delay Airtable automation runs
- Prevent automations from triggering by mistake
- Use automations to timestamp status updates
- Automation Triggers
- Airtable Triggers
- Airtable automation trigger: When record matches conditions
- Airtable automation trigger: When a form is submitted
- Airtable automation trigger: When record created
- Airtable automation trigger: When record updated
- Airtable automation trigger: When record enters view
- Airtable automation trigger: At scheduled time
- Airtable automation trigger: When webhook received
- Airtable automation trigger: When a button is clicked
- Airtable automation trigger: When email received Updated
- Integrated Triggers
- Airtable Triggers
- Automation Actions
- Airtable Actions
- Airtable automation action: Send email Updated
- Airtable automation action: Create record
- Airtable automation action: Update record
- Airtable automation action: Find records
- Airtable automation action: Sort list
- Airtable automation action: Run a script Updated
- Airtable automation action: Generate with AI
- Integrated Actions
- Airtable automation actions: Slack
- Airtable automation actions: Google Workspace
- Airtable automation action: Send MS Teams message
- Airtable automation actions: Outlook
- Airtable automation actions: Jira Cloud
- Airtable automation actions: Jira Server / Data Center
- Airtable automation actions: Salesforce
- Airtable automation action: Create post in Facebook Pages
- Airtable automation actions: GitHub Issues
- Airtable automation action: Hootsuite post
- Airtable automation action: Send Twilio SMS
- Airtable Actions
- Airtable Bases
- Using Airtable Cobuilder
- Airtable bases overview
- Creating and managing Airtable bases
- Structuring bases in Airtable
- Moving bases between workspaces in Airtable
- Creating and managing tables in Airtable
- Creating Airtable base share links
- Importing third-party data into Airtable
- Using insights in Airtable
- Troubleshooting Airtable base performance
- Airtable Betas
- Collaborating in Airtable
- Airtable Enterprise Support
- General Enterprise information
- External badging in Airtable
- Using app library and components in Airtable Updated
- Ask an Expert beta overview
- European data residency at Airtable
- Airtable user groups overview
- Airtable Enterprise API
- Creating and managing data retention policies in Airtable
- eDiscovery APIs in Airtable
- Airtable and data loss prevention
- Accessing Enterprise audit logs in Airtable
- Set up Jira Server / Data Center to connect with Airtable
- Admin panel pages
- Airtable admin panel overview
- Users - Airtable enterprise admin panel
- Airtable admin panel user details
- Groups - Airtable admin panel
- Workspaces - Airtable Enterprise Admin Panel
- Bases - Airtable admin panel
- Interfaces - Airtable admin panel
- Data sets - Airtable admin panel
- Managed apps - Airtable admin panel
- Components - Airtable admin panel
- Reports - Airtable admin panel
- Settings - Airtable admin panel Updated
- Managing Enterprise organizations
- Managing Enterprise admins in admin panel
- Using Organizations
- Organization branding for apps in Airtable
- Enterprise Hub in Airtable
- Enterprise Hub: Org unit assignment with user groups Updated
- Deactivating, removing access, and reactivating users in the admin panel
- Managing user access to workspaces and bases
- Airtable Enterprise Key Management Updated
- Custom terms of use New
- Enterprise SSO
- General Enterprise information
- Airtable Extensions
- Airtable Fields
- Fields Overview
- Attachment
- Date-based fields
- Formula
- Getting Started with Formulas
- Formula Foundations
- The essentials of Airtable formulas
- Formula writing tips for beginners
- Troubleshooting formulas
- Basic calculations
- Conditional statements
- Logical arguments
- Working with dates
- Displaying DATETIME_FORMAT using the date field in Airtable
- Working with date functions in Airtable
- Calculating the difference between dates in Airtable
- Supported DATETIME_DIFF unit specifiers in Airtable
- Supported DATETIME_FORMAT format specifiers in Airtable
- Using the DATETIME_PARSE() formula in Airtable
- Working with timezones
- Record functions
- Text functions
- Numeric functions
- Common Solutions: Beginner
- Common Solutions: Intermediate
- Common Solutions: Advanced
- Long Text Field
- Linked Record Field
- Linking records in Airtable
- Limiting linked record selection to a view in Airtable
- Dynamic filtering in linked record fields
- Linking to one, many, or a subset of Airtable records
- Converting existing fields to Airtable linked records
- Reordering record links in Airtable
- Understanding linked record relationships in Airtable
- Number-Based Fields
- Other Fields
- Rollup, lookup, and count fields
- Select and user fields
- Integrating with Airtable
- API
- Getting started with Airtable's Web API
- Creating personal access tokens
- Airtable Webhooks API Overview
- Service accounts overview
- Airtable Web API - Using filterByFormula or sort parameters
- Airtable API Deprecation Guidelines
- Airtable API: Common troubleshooting
- Managing API call limits in Airtable
- URL length limitations for web API requests
- Integration services
- Third-party integrations via OAuth overview
- Troubleshooting disconnected OAuth integrations in Airtable
- Options for integrating with Airtable
- Third-party integrations - Common troubleshooting
- Low-code integrations - Common troubleshooting
- Integrating Airtable with external calendar applications
- Visualizing records from Airtable in Tableau
- Visualizing Airtable records in Microsoft Power BI & Power Query
- Integrating HubSpot with Airtable
- Using Zapier to integrate Airtable with other services
- Using Zapier's Multi-Step Zaps to find and update records
- Using IFTTT to integrate Airtable with other services
- Integrating with AWS Lambda & DynamoDB
- Developer tools
- API
- Airtable Interface Designer
- Interface Designer overview articles
- Interface layouts
- Interface elements
- Adding and removing elements in interfaces
- Adding layouts to interfaces
- Formatting elements in interfaces
- Interface element: Button
- Interface element: Calendar
- Interface element: Chart
- Interface element: Filter
- Interface element: Gallery
- Interface element: Grid
- Interface element: Kanban
- Interface element: Number
- Interface element: Record picker
- Interface element: Text
- Interface element: Timeline
- Learning and Resources
- Managing Airtable
- Airtable Policy
- Airtable Records
- Airtable Sync
- Airtable Views
- Airtable Workspaces
- Print
- Share
- DarkLight
- PDF
Supported field types in Airtable overview
- Updated on 29 Jan 2025
- 5 Minutes to read
- Print
- Share
- DarkLight
- PDF
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. | |
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. | |
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. | |
Button | button object | The button field adds interactivity to your record such as opening a URL. | |
Checkbox | boolean | A checkbox field is useful for true/false values within a record. | |
Count | number | A count field lets you count the number of linked records in a record link column. | |
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 By | collaborator object | The created by field will automatically show which collaborator created a record within the base. | |
Currency | number | A currency field is a specific type of number field that formats the number as a currency amount. | |
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. | |
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.) | |
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. | |
Last modified by | collaborator object | The last modified by field displays which collaborator made the most recent change to a record. | |
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 | |
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. | |
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. | |
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. | |
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. | |
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%. | |
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. | |
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. | |
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 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. |
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.