Home
Blog
Rollup and Lookup Fields in Airtable - including conditional settings
Airtable
November 7, 2022
|
1 min reading

Rollup and Lookup Fields in Airtable - including conditional settings

Learn how and when to use Lookup and Rollup fields in Airtable - this training will showcase some complex examples including conditional rollups and recent dates

Rollup and Lookup Fields in Airtable - including conditional settings

Table of Contents

Text Link
Book a call

Linking tables is one feature that helps Airtable stand out. With links, creators reduce redundant data entry because everything lives in your database in just one place. But, for those times when you need to access information from a linked table, how do you bring in the relevant information? For these cases, we rely on Lookup and Rollup fields!

Lookup fields allow us to access linked records and bring data in specific fields. Rollup fields work the same, with the extra bonus of being able to perform an aggregation function.

This training starts by showcasing the use of a simple Rollup field. From there, we then expand to build a conditional Rollup that only uses some of our records. Lastly, we look at an advanced use case that calculates the most recent date.

Gareth Pronovost
Gareth Pronovost
Founder & Lead Consultant

Gareth Pronovost is the founder of GAP Consulting, an Airtable-first consultancy that helps businesses replace manual workflows with systems that scale. A former corporate finance analyst turned no-code educator, he has taught hundreds of thousands of builders through his YouTube channel and led systems builds for organizations ranging from solo founders to Disney and Ticketmaster.

Ready when you are

Not Sure Where to Start?

Take our free 2-minute quiz and get a personalized no-code roadmap built around your goals.

Light gray decorative footer background