Contents x
Rollup, lookup, and count fields
8 Articles  in this category
  • Print
  • Dark
    Light
Contents

Rollup, lookup, and count fields

8 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. Add the rollup field To add a rollup field, click the plus sign located to the right of ...
Updated on : 06 Jul 2022

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 Aug 2022

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. FAQs Can the count field be reset? The count fiel...
Updated on : 06 Jul 2022

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. The following functions can be used to aggregate your rollup values.
Updated on : 06 Jul 2022

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

Does filtering affect rollup fields?

By default, any filtering conditions applied in a view of a table will not affect a rollup of those records in another table. A rollup field will roll up data from all records in the target linked table, regardless of whether or not those re...
Updated on : 06 Jul 2022

Vlookup functionality in Airtable

If you're coming from spreadsheets, it can be confusing to understand how to pull information from one table to another. In this Table Talk clip, Aron covers how to understand the differences between a VLOOKUP function in a spreadsheet and the look...
Updated on : 02 Nov 2022