Using Lookup and Rollup Fields in Airtable | Conditional Rollups

Lookup and Rollup fields allow creators to access information in their database based on linked records. This video shows how Airtable users can create conditional rollup fields and also includes an advanced use case including recent dates. 👇

_________________________________________


Learn more at these links: 🔗 👇

Learn the basics of Airtable Automation!
https://www.garethpronovost.com/webin...

Take our free Airtable Crash Course!
https://garethpronovost.com/airtable-...

Getting Stuck? See how we can help!
https://garethpronovost.com

Get our Airtable Field Type download!
https://www.gapconsulting.io/airtable...

_________________________________________


Table of Contents: 📖 👇

00:00 - What this video covers
01:15 - Outline the Data Schema
01:43 - Stating the "Problem"
02:12 - What is a Lookup or Rollup Field
02:39 - Total Order Amount Rollup
03:52 - Conditional Total Amount Rollup
05:47 - Accessing the Most Recent Data
11:04 - Adding new orders for testing
12:38 - How to Get More Help!

_________________________________________


Software Resources (may contain affiliate links): 💻 👇

Airtable - https://airtable.com/invite/r/v0eI3ASY

_________________________________________


#nocode #GarethPronovost #Airtable #GAPConsulting