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)
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
Absolutely - if you change prices then all calculations will not reflect accurate historical data. To overcome this, we suggest creating new records when price changes are implemented. This way the historical data will still be accurate but you can now link to the updated price moving forward. To make this more robust, consider archiving or deactivating the old price records so that it is filtered out for future use.
Yes, we've worked at this over the past 5 years or so. Our team completes discovery sprints before working with a client, where the aim is to map out the workflow, process, and subsequent data schema requirements. We've developed our own methodology for this over time.
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!
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
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
Automations should stay with the database when you create a copy. I'm stumped as to why that isn't happening for you, unless Airtable removed this feature. 🤷♂️
It really depends on your use case. Most of the time we will default to linking with automation wherever possible. We'll typically use a script as a last resort, especially now that Airtable has enabled looping automation that will perform multiple links.
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!!!!!!
This is a more advanced use case that native Airtable forms can't handle. However, there is 3rd party form software that can handle this based on the dependencies in your Airtable base! Check out Fillout - we've done videos on them here on our channel and they can help with this!
![ละลาย (LALALYE) - DAOU PITTAYA ต้าห์อู๋ พิทยา [OFFICIAL MV]](http://i.ytimg.com/vi/wo6r9TgausI/mqdefault.jpg)
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)
This was awesome, explained well to understand 🙌🏼
Thanks for your great support🤗
Great video. Just bought the course.
life saver you are. Super valuable.
Thank you for watching! 🙌
Amazing video, learned a lot🙏 Namaste, Dhanyavaad (Gratitude) from India!
Thank you!
Thank you!! Exactly what I needed. I couldn't see how tables were connected in my head. You made it all "connect." :)
glad this helped!
Precisely what I was looking for. Fantastic video! 👍
Glad this helped!
Bravo. 👏 amazing work.
Badass tutorial. Thanks!
Thanks for watching!
Muchas gracias!! Muy buena la explicación!
Thanks for watching!
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
curious - what happens when the price changes, will the totals on previous orders change as well? How do you maintain historical accuracy?
Absolutely - if you change prices then all calculations will not reflect accurate historical data. To overcome this, we suggest creating new records when price changes are implemented. This way the historical data will still be accurate but you can now link to the updated price moving forward. To make this more robust, consider archiving or deactivating the old price records so that it is filtered out for future use.
Brilliant 👏🏻
Excellent
thanks for the video! Do you have a specific way/methodology to understand the relationship aka design the database schema ?
Yes, we've worked at this over the past 5 years or so. Our team completes discovery sprints before working with a client, where the aim is to map out the workflow, process, and subsequent data schema requirements. We've developed our own methodology for this over time.
@@GarethPronovost thanks!
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!
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
Effing amazing!
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
Automations should stay with the database when you create a copy. I'm stumped as to why that isn't happening for you, unless Airtable removed this feature. 🤷♂️
@@GarethPronovost thank you ! Could this be due to having a pro package on airtable?
Possibly an ode to John Galt behind you?
Hmmm, who is John Galt?
very useful! :)
What are the pros and cons of linking records with a script vs with a non-scripted airtable automation?
It really depends on your use case. Most of the time we will default to linking with automation wherever possible. We'll typically use a script as a last resort, especially now that Airtable has enabled looping automation that will perform multiple links.
Fast and helpfull
Thanks for watching!
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!!!!!!
This is a more advanced use case that native Airtable forms can't handle. However, there is 3rd party form software that can handle this based on the dependencies in your Airtable base! Check out Fillout - we've done videos on them here on our channel and they can help with this!
@@GarethPronovost Thanks for taking the time to answer. Really appreciate it.
then how to unlinked ?
good video but at the end there you went so fast i lost you
Sorry for the quick speed at the end
No words, just likessssssss. Get to the top FAST = *Promo sm*.