Contents x
Fields Overview
12 Articles  in this category
  • Print
  • Dark
    Light
Contents

Fields Overview

12 Articles in this category
  • Dark
    Light

Adding a field

To add a field (column) to your table, simply scroll as far right as you can on your table, then click the large + button. Note that we only support manually adding one field at a time. You can also add a new field by clicking on a field heade...
Updated on : 01 Jul 2022

Field types overview

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 ...
Updated on : 24 Aug 2022

Searching for fields

In bases with many fields, it may become tedious to scroll in order to find the particular field that you are wanting to look at or edit. In these cases, within a grid view, it's possible to search for a particular field by name. At this time, other...
Updated on : 30 Aug 2022

Update multiple fields with bulk field actions

Using bulk field actions you can make changes (including field permissions, grouping, filtering, and hiding) to multiple fields at the same time. How to select multiple fields To select multiple fields, start by clicking on one of the field names ...
Updated on : 24 Aug 2022

The primary field

The primary field is akin to the concept of a primary key in relational databases. In Airtable, the primary field is most often a text type field. However, it can also support many other field types including, but not limited to, date, number, auton...
Updated on : 24 Aug 2022

How can I change the primary field in my table?

The primary field serves as the unique identifier for each record and cannot be deleted, however you can easily replace the data in that field by changing the field type or copying over data from another field. We do not currentl...
Updated on : 01 Jul 2022

Hiding fields and field visibility overview

One of the core features of views is the ability to hide specified fields (columns, in grid views). When a field is hidden, it is not deleted and none of the values in that field are affected—it's just hidden from the particular view you're using ...
Updated on : 24 Aug 2022

Duplicating a field to a new table

To copy a field (column) from one table to another, you can copy any cell from the existing field, then paste it into a new empty text field in a different table (Ctrl+C, Ctrl+V for PC; ⌘+C, ⌘+V for Mac). This will also copy over the field settings....
Updated on : 01 Jul 2022

How do I delete a field (column)?

To delete a field (column), click on the menu icon in the column header of the field you'd like to remove. Select the "Delete" option. At this time it's only possible to delete one field at a time. Note that the primary field (the first field ...
Updated on : 01 Jul 2022

Adding a 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. To add a field description, click on the dropdown arrow in the header of the field to which you wish t...
Updated on : 27 Jun 2022

Field Manager and field dependencies

The field manager is Airtable's new surface focusing on table configuration — giving Pro and Enterprise users more control over permissions and settings for things like schema fields and field configurations . Use cases for field manager and dep...
Updated on : 22 Aug 2022

Customizing the field type

You can customize the field (column) type in the field customization menu. To open the field customization menu from a grid view, click on the dropdown arrow icon in the header of the field to bring up the field menu. From there, you can select the...
Updated on : 24 Aug 2022