Kuovonne's Guide to Airtable

Explore

Kuovonne's Guide to Airtable

Fields

Converting Field Types
Converting Field Types

⁠

⁠ Tip Jar ⁠ Thank Kuovonne for creating this content! ⁠ ⁠ ⁠

⁠

When converting one field type to another Airtable will do its best to retain any existing data.

Converting to a linked record field

When you convert a field to a linked record field, what happens depends on the target table and its primary field.

Linking to an existing table with an editable primary field. Airtable will match records where possible, and create new records where there are no matches. Airtable will create an inverse link field in the other table (unless you are creating a same-table link).

Linking to an existing table with a computed primary field. Airtable will match records where possible, but not create new records where there are no matches. If there is no match, you will loose the data in the original field. Airtable will create an inverse link field in the other table (unless you are creating a same-table link).

Linking to a new table. Airtable will create a new table with an editable primary field. The new table will have two fields: an editable primary field and the inverse link field.

Check the name of the inverse link field that is created to ensure that it has a meaningful name.

Quickly creating many select field choices

Create a single line text field.

Type or copy/paste the choices, one per line.

Convert the field to a select field.

⁠

⁠ ⁠ Thank Kuovonne for creating this content! ⁠ Give Kuovonne a sandwich ⁠ Signup for Coda w/ referral link ⁠ ⁠ ⁠Buy from my Gumroad Store ⁠ ⁠ ⁠ ⁠ ⁠

⁠

Gallery

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.

Converting Field TypesConverting Field Types

Converting to a linked record field

Quickly creating many select field choices

Converting Field Types
Converting Field Types