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!
www.garethpronovost.com/webin...
Take our free Airtable Crash Course!
garethpronovost.com/airtable-...
Getting Stuck? See how we can help!
garethpronovost.com
Get our Airtable Field Type download!
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 - airtable.com/invite/r/v0eI3ASY
_________________________________________
#Nocode #GarethPronovost #Airtable
Пікірлер: 8
Check your Airtable skills with my *free crash course* 👉👉 garethpronovost.com/airtable-crash-course 👈👈
What a fantastic tutorial video! I like it so much.
Good stuff as always! This is why most of us are out of fields lol #giveusmorefields
@GarethPronovost
Жыл бұрын
Crazy that we need this many fields to calculate a single value! I'd love more fields, but I also wish there was a simpler way to produce this result with fewer fields required!
@reallyefficient
Жыл бұрын
@@GarethPronovost #truth!!
i'm not following why you needed to create that rollup field in this case. was the lookup you did dependent on having the rollup? it seems like you could have just created the lookup alone. i guess i don't understand the purpose of rollups and how they help you understand your data more clearly.
It is better to look up the linked field directly so you can click on it instead of your "Task name to be shared". You just need to create a field Order Diff Formula = Max Order Completed - Order # and then you filter to show only where Order Diff Formula = 0
@GarethPronovost
Жыл бұрын
You'll have to demo that one, I haven't heard of this approach before!