- 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
Plan availability | All plan types |
Permissions |
|
Platform(s) | Web/Browser, Mac app, and Windows app (Add mobile apps if relevant) |
Related reading |
|
Airtable terminology |
|
Field configuration menu
A field type specifies the kind or format of data stored in a given field — for example, long text, date, multiple select, or attachment. Users can customize most field types within their base.
Note
When customizing the field type for the primary field, only some field types are available. For more information on customizing the primary field please see this article.
Accessing the field configuration menu
To access the field configuration menu, click on the dropdown arrow next to the name of the field you want to edit.
![](http://cdn.airtable.document360.io/d0ee2ee4-3f78-47c7-b388-85e40be9fb89/Images/Documentation/fields_edit_find_configuration_12012022.gif)
You can also access some of the field configuration options by expanding a record, then clicking the dropdown arrow icon in the header of the field you wish to customize.
![](http://cdn.airtable.document360.io/d0ee2ee4-3f78-47c7-b388-85e40be9fb89/Images/Documentation/fields_customize_expanded_record_options_12012022.jpg)
Editing a field
With the field configuration menu open, click the Edit field option. Alternatively, you can double-click on the field header to open the editing menu. This will open a new menu of options where you can:
Rename the field
Change the field type 1
Configure additional options available for that field 1
Certain field types also offer the ability to set default values when a record is created. More on this functionality is available here.
Add/modify/delete the field's description
Click Cancel at anytime to clear any edits you may have made. When you are finished editing the field, click Save.
Edit field description
If the title of your field could use a longer explanation, you have the option of adding a more detailed field description to each of your fields. Now, whenever you or other collaborators in the base mouse over the information icon in the field header, your description will appear.
![](http://cdn.airtable.document360.io/d0ee2ee4-3f78-47c7-b388-85e40be9fb89/Images/Documentation/field_edit_description_12022022.gif)
Duplicating a field
To duplicate a field click the Duplicate field option from the configuration menu. Clicking this option will create a new field with duplicate settings. The name of the field will be appended with the word "copy" at the end. So, for example, a field named "Notes" will become "Notes copy." You can click the configuration dropdown in this new field to adjust its settings.
![](http://cdn.airtable.document360.io/d0ee2ee4-3f78-47c7-b388-85e40be9fb89/Images/Documentation/field_duplicate_option_12012022.jpg)
Deleting a field
To delete a field click the Delete field option from the configuration menu. As a reminder, if you accidentally delete a field, then you can restore it from the base trash.
![](http://cdn.airtable.document360.io/d0ee2ee4-3f78-47c7-b388-85e40be9fb89/Images/Documentation/fields_delete_option_12012022.jpg)
Inserting a new field
You can also insert a new field to the left or right of the current field configuration menu you have opened. This is especially helpful in tables/views that contain many fields because the plus sign used to add a new field will be to the right of the last field.
![](http://cdn.airtable.document360.io/d0ee2ee4-3f78-47c7-b388-85e40be9fb89/Images/Documentation/fields_insert_right_left_12012022.gif)
Additional field actions
The following options are covered in other documentation:
Setting default values in fields
Adding default values to a field
In fields where default values are supported:
Navigate to the base and table containing the field where you would like to add a default value.
Click the dropdown next to the name of the field.
Select the Edit field option.
In most fields, you will see a “Default” section that you can fill in or update.
Note
Default values will only appear when new records are created. If you configure a field to have default values or alter it to have new default values, that change will not be reflected in any records that existed before the default setting was changed.
Field types that support setting default values
Checkbox
Currency
Date
Multi select
Number
Percent
Single line
Single select
User
Note
Default values cannot be configured in primary field types.
Changing field type dependencies
After changing a field with an existing value into a new field type, Airtable works to convert those current cell values to the new type. For example, you can convert a single line text field into a single select field or user field. However, note that some conversions may not be possible with certain types—like converting a text field to an attachment field clears the text values as plain text values do not represent an attachment.
After selecting a new field type, you have the option of customizing the field even further. Different field types have different customization options. For example:
An attachment field has no additional customization options.
A number field lets you set whether the numbers in that field should be formatted as integers or decimals (and if so, the degree of precision for decimals), whether or not to allow negative numbers, and whether or not you want the field to have a default numerical value.
A formula field lets you define a formula to determine the values in that field.
For more information on each field type and its specific customization options, check out our field types overview article.