- 27 Sep 2024
- 3 Minutes to read
- Print
- DarkLight
- PDF
Lookup field overview
- Updated on 27 Sep 2024
- 3 Minutes to read
- Print
- DarkLight
- PDF
This article covers using the lookup field to streamline your team's and organization's work.
Introduction
All plan types | |
Platform(s) | Web/Browser, Mac app, and Windows app |
Related reading | |
Try it in Airtable |
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
Visit your Airtable homepage.
Create or open your preferred base.
Add or edit a field.
Search for and select Lookup.
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.
Click Create field.
Customizing lookup fields
Visit your Airtable homepage.
Create or open your preferred base.
Add or edit a field.
Search for and select Lookup.
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.”
Click the ⌄ icon under the “Select lookup source” section and choose your preferred source.
Click the ⌄ icon under the “[your preferred source] field you want to look up” and choose your preferred field.
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.
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:
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, it also 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.