Grab my *Free Airtable Crash Course* here garethpronovost.com/airtable-crash-course

Bro is actually so good at teaching.

I'm addicted to your Airtable content. Wondering if you might be able to do some follow-up videos on suggested workflow and automations for some of these tables that you create. This video is a perfect example -- seeing the table structure itself is a super helpful first step, but I'm still left with some questions: 1. What mechanism(s) should be used to input data. A form from the order view? A form from the line item view? 2. What automations could be layered on top of the form to ensure easy/automated input, and the creation of linked records? I think fleshing out those questions would be really helpful to your audience (At least... very helpful to one member of your audience :P)

Thank you!! Exactly what I needed. I couldn't see how tables were connected in my head. You made it all "connect." :)

Precisely what I was looking for. Fantastic video! 👍

Amazing video, learned a lot🙏 Namaste, Dhanyavaad (Gratitude) from India!

Thanks for your great support🤗

life saver you are. Super valuable.

Great video. Just bought the course.

Bravo. 👏 amazing work.

Time Stamps 3:02 add field and link companies to clients tables 8:16 Junction table- more advanced linking 9:43 how not to connect orderes to inventory 10:48 build intermediary table 1:06 add integer column 12:25 primary column formula 12:49 add inventory column 13:42 Roll up demo (use orders table) connect Orders table to "line items" table 14:38 recap

Muchas gracias!! Muy buena la explicación!

Brilliant 👏🏻

Excellent

Effing amazing!

very useful! :)

Thanks for the great video. I've watched it several times for different needs. Does this apply for splitting a bill among several friends at dinner? I'm part of a book club and each month we get together to share drinks and food. It's always a mess once the bill comes - who ordered what, who split what with whom, each person's total... Do I need 4 different tables to use a junction and to find out the total for each person with their own orders and split items? For example between 4 people, a bottle wine is split 4 ways, a salad 2 ways, an appetizer 3, a lemonade one. Thanks for your help!

Fast and helpfull

I simply want to be able to make a selection on a multi select eg Skip Bins size. and then automatically fill out the Skip Bin Price? Ive tried to make it an automation but it doesnt seem to work

Possibly an ode to John Galt behind you?

What are the pros and cons of linking records with a script vs with a non-scripted airtable automation?

thanks for the video! Do you have a specific way/methodology to understand the relationship aka design the database schema ?

hi!!!! I'm trying to do a form. Here's the situation: We have teachers and students. Every teacher may have more than 1 student and the same happens to the students. So In a form, once I pick the field teachers, the next field (students) just shows me the students vinculated to that teachers. I'm new in airtable and i'm going in circles with that. Thanks!!!!!!

Hi Gareth, thank you for your inspiring videos! A question, how do you sell an airtable base with automations to a client? when I share my database, the automations disappear... Do you have an idea how to do it well? Thanks

good video but at the end there you went so fast i lost you

No words, just likessssssss. Get to the top FAST = *Promo sm*.