Lookup field overview
  • 27 Jan 2024
  • 3 Minutes to read
  • Dark
    Light
  • PDF

Lookup field overview

  • Dark
    Light
  • PDF

Article Summary

This article covers using the lookup field to streamline your team's and organization's work.

Introduction

Plan availability

All plan types

Platform(s)

Web/Browser, Mac app, and Windows app

Related reading

Try it in Airtable

Add a lookup field

Adding lookup fields in Airtable

The lookup field allows you to pull content stored in records from one linked record into another. However, keep in mind that lookup fields require a linked record to create a connection between two tables. To use a lookup field, start by configuring a linked record field.

Adding lookup fields

  1. Visit your Airtable homepage

  2. Create or open your preferred base.

  3. Add or edit a field.

  4. Search for and select Lookup

    1. From here, a window opens, allowing you to select your “Lookup source,” choose what you want to look up, toggle ON/OFF “Only include linked records from that meet certain conditions,” and toggle ON/OFF “Limit the number of items shown.” For additional details, visit the “Customizing lookup fields” section below.

  5. Click Create field.

Customizing lookup fields

  1. Visit your Airtable homepage

  2. Create or open your preferred base.

  3. Add or edit a field.

  4. Search for and select Lookup

    1. From here, a window opens, allowing you to select your “Lookup source,” choose what you want to look up, toggle ON/OFF “Only include linked records from that meet certain conditions,” and toggle ON/OFF “Limit the number of items shown.”

  5. Click the icon under the “Select lookup source” section and choose your preferred source.

  6. Click the ⌄ icon under the “[your preferred source] field you want to look up” and choose your preferred field.

    1. In addition, you can optionally toggle ON/OFF “Only include linked records from that meet certain conditions.” By enabling this feature, you can filter out records that don’t meet your preferred conditions.

    2. You can also optionally toggle ON/OFF “Limit the number of items shown.” By enabling this feature, you can select a limit for displayed items.

Lookup and formula fields

NOTE

The information displayed in a lookup field is collected into a list of values known as an array. In a formula field, you cannot directly access a lookup field's values; you can access the list of values together as a unit.

Suppose you reference a lookup field within a formula field. In that case, you may need to initially convert the values into a data type the formula you are working with can accept. We recommend checking out our Array functions when working with a lookup field directly within a formula. Alternatively, we recommend using a Rollup field, which can use a formula on a linked record's field

In situations like having a linked record field with multiple records., you'll want to change how information returned from a lookup field appears. If multiple linked records exist, the lookup will concatenate the cell values and separate them with a comma.

While changing the comma separator to another symbol is impossible, you can use a rollup field instead of a lookup field. For this approach:

  1. Add and configure a rollup field.

  2. Copy and paste SUBSTITUTE(ARRAYJOIN(values), ",", " + ")into the rollup aggregation formula.

NOTE

By using the formula above, the rollup field can substitute the comma separator with something like a "+" icon. You can change the "+" icon in this formula with any symbol you'd like to use as a separator.

FAQs

Do lookup fields carry over formatting?

We do not currently support rich text formatting in lookup fields. For more information please see this support article.

How do I format a rollup field's output?

Consult this support article for more information on number-based field formatting.

What fields require linked records to function?

  • A lookup field returns the value(s) for a specific field from a linked record (or records). You can use this to bring information from one table into another table without duplicating it, so that your information will always be up-to-date in all tables.

  • A count field returns the number of linked records in a linked record field.

  • A rollup field is a bit like a lookup, but instead of just returning the value(s) from a field in a linked record, italso performs a calculation on those values—like summing together all the values from the linked records, or returning only the maximum value from the linked records.


Was this article helpful?