Contact Support
Sign up for free
English
English
French
German
Account
Account overview
Billing
Policies
API
API Overview
Get your API key
Documentation
Troubleshooting
Integrations
Resources
Community
Enterprise
Admin Panel
Enterprise Plans
Airtable Security
Terms of Service
Privacy Policy
Resources
Community
Marketplace
Templates
Universe
Contents
x
Getting started with Airtable
Airtable Automations
Airtable Bases
Airtable Betas
Collaborating in Airtable
Airtable Enterprise Support
Airtable Extensions
Airtable Fields
Integrating with Airtable
Learning and Resources
Airtable Interface Designer
Managing Airtable
Airtable Policy
Airtable Records
Airtable Sync
Airtable Views
Airtable Workspaces
Powered by
Rollup, lookup, and count fields
6 Articles
in this category
Print
Dark
Light
Contents
Rollup, lookup, and count fields
6 Articles
in this category
Dark
Light
Rollup field overview
A rollup field performs calculations, creates aggregates, and builds formulas on specific cells from records that are linked to another field in your table. Introduction Add the rollup field To add a rollup field, click the plus sign located to...
Updated on : 24 Jul 2023
Lookup field overview
A lookup field allows you to pull record contents from one linked record into another linked record. As a reminder, linked relationships can be either within the same table or across two separate tables. You could design a self-linking linked rec...
Updated on : 24 Jul 2023
Count field overview
A count field lets you count the number of linked records in a record link column. To configure a count column, you simply choose the column with the linked records that you want to count. Introduction Setting up a count field The count field i...
Updated on : 23 Aug 2023
Rollup field reference
A rollup field aggregates specific cells from records that are linked to another field in your table. For an overview of rollups, check out the Rollup field overview. Introduction The following functions can be used to aggregate your rollup...
Updated on : 24 Jul 2023
Conditional counts, lookups, and rollups
Lookup, rollup, and count fields in a table use linked record fields to pull in values from one table to another. By default, these fields will pull in all the linked records from the other table, but you can choose to apply conditions to filter on ...
Updated on : 06 Jul 2022
Fields that require linked records to function
Linked records are required to use three field types: lookup, count, and rollup. 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 ...
Updated on : 24 Aug 2022