How To Quickly Find The Most Recent (Linked) Value In Airtable
Learn how to perform advanced lookups in Airtable between linked tables. This may sound easy, but it’s a surprisingly complex process of creating lookup fields and using rollup fields to aggregate data based on conditional information. If you can master this skill, you are on your way to becoming an Airtable Pro! 👇
_________________________________________
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:44 - looking at our structure and problem
03:03 - What we want to know
04:35 - How to build a look up field
05:17 - Setting conditional information
06:24 - Using a roll-up field
08:14 - Applying a formula
10:12 - Finishing the process
10:55 - Testing this process
12:00 - Signing off
_________________________________________
Software Resources (may contain affiliate links): 💻 👇
Airtable - https://airtable.com/invite/r/v0eI3ASY
_________________________________________
#Nocode #GarethPronovost #Airtable