Get our *FREE AIRTABLE CRASH COURSE* here 👉👉 garethpronovost.com/airtable-crash-course ⚡⚡ Follow along in Airtable here 😍😍 airtable.com/invite/r/v0eI3ASY 🤓🤓

I heart junction tables. I've been working in Airtable for a few years now but feel like I need to bookmark this video because it constantly reminds me to make things more granular for more control. Thanks!

@GarethPronovost

Ай бұрын

Glad to hear this, because I often feel like we keep posting the same concepts over and over again, but the idea of a junction table is so critical to building databases I do it anyway because everyone needs to hear about it!

Hi Gareth ! Thanks for this spot-on video. I would like to see now, as a sequel, how you manage price changes (example 1 or 3) in Airtable. Obviously if the hourly price (example 1) increases then the historical data are updated and become wrong. How you actually avoid this in Airtable is interesting. I have built a Temporary table to build up each new line item, then an automation copies it into the "final" junction table. Is there another way ? Thanks for the hours and hours of recording you make for the community. Christophe.

@GarethPronovost

Ай бұрын

Thank you for the excellent video idea! We'll add this to the queue!

@GarethPronovost Thanks! But is a Junction Table the same as a Pivot Table and if not, what is the difference between the two and when might you want to use one or the other? (Might make a good followup video) :)

@GarethPronovost

2 ай бұрын

Hi! A junction table is a third table that connects two other tables together in a "junction" - a pivot table is a tool to visualize data across multiple variables. Hope this helps!

Great tutorial! How does this work through the API? With the invoice example, could you GET the invoice record and all the nested line items with the details of the referenced services in a single request?

@GarethPronovost

3 ай бұрын

Great question and YES! However if you don't get all the linked records, you can also perform a search function to get them in a separate request. Check out tools like DocsAutomator and Documint for PDF creation from a setup like this. 💪

I'm SO CLOSE to understanding this! My question is, how do you make sure the junction table is automatically updated to match the class/student tables? I'm trying to build a junction table for trips that staff in my dept go on. I've got a Trips table and a People table that are linked. So on the junction table I want a line item for each person grouped by trip (just like you have line items for each student grouped by class). I can't figure out how to build the automations that will create or delete the line items as people join or leave trips. Am I missing something obvious?

@GarethPronovost

2 ай бұрын

You can definitely do this with an automation - for example, you can say that you wish to build all of the junction records when you create a new Trip record. Then, search for all the People in the People table and create a new record for each one of them in your junction table that links to the new trip!

Excelente

@GarethPronovost

3 ай бұрын

Thank you!

@TedMast

3 ай бұрын

Great, thank you Gareth! I've been trying to figure out an airtable issue at work today and this is still a great reminder that a junction table is most likely going to be the solution.