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!
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!
Hello Gareth, I hope you are doing well. I really appreciate your time for making this quick video. I just wanted to check if I can merge 2 tables into one as a junction table provided that both the tables have different fields and there is one primary key! For say there are 100 records in one table and 1000 records in another table is there a way I can import those additional 900 records in the junction table? Few fields may remain blank and it is okay! I just want to merge both. Let me know if you have any suggestion. Thanks.
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.
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?
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?
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!
@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) :)
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, 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.
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!
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!
Hello Gareth,
I hope you are doing well.
I really appreciate your time for making this quick video. I just wanted to check if I can merge 2 tables into one as a junction table provided that both the tables have different fields and there is one primary key! For say there are 100 records in one table and 1000 records in another table is there a way I can import those additional 900 records in the junction table? Few fields may remain blank and it is okay! I just want to merge both. Let me know if you have any suggestion.
Thanks.
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.
Thank you for the excellent video idea! We'll add this to the queue!
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?
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. 💪
How to manage airtable junction table in softr. Like add /edit invoice line items in softr
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?
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!
@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) :)
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!
Excelente
Thank you!
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.