Rollup, lookup, and count fields

Rollup field overview
  • Updated on Oct 29, 2024
  • Published on Jul 6, 2022
A rollup field performs calculations, creates aggregates, and builds formulas on specific cells from records that are linked to another field in your table. Adding rollup fields in Airtable NOTE To use rollup fields, your base must have a ...
Lookup field overview
  • Updated on Nov 25, 2024
  • Published on Jul 6, 2022
Adding lookup fields in Airtable The lookup field allows you to access and use content stored in one linked record for use in another. NOTE Lookup fields require a linked record to create a connection between two tables. To use lookup ...
Count field overview
  • Updated on Sep 30, 2024
  • Published on Jul 6, 2022
This article details how to use count fields to count the number of linked records in a record link column. Creating count fields in Airtable NOTE Your base's table must have a linked record field before creating a count field. T...
Applying conditions to count, lookup, or rollup fields in Airtable
  • Updated on Jan 3, 2025
  • Published on Jul 6, 2022
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...