Thanks for this Gareth! It is sometimes tricky to summarize to my students what are Rollup fields and how they could be really useful, depending on the use case. But now you gave us the perfect tutorial to show them!
Thanks Gareth. I come from an ERP developer background and have a comment/suggestion on your max date scenario. In many ERP softwares (such as my platform, Peoplesoft), they have tables with "effective dates" and they also have "effective status". This allows you to do a lookup of a row of data that is active and less/equal to current date. Because in some cases you have a future date for a price change for next month or something. I think a video on handling future dated lookups that allow a user to schedule a data change in the future and let their system handle it automatically would be a useful tutorial. If that already exists, ignore :). Thanks.
Ah, great suggestion! Airtable does have lookup fields that can be filtered to include specific data, so I think you could accomplish this fairly simply. Thanks for the idea 💡
Very nice example of the Lookup and Rollup Fields! I wish this video came out a couple years ago... it really solidifies how to grab information from a different table and filter the information. It highlights how Airtable can be used to track orders. Filtering by date in Airtable can be tricky. I liked how you resolved the max date. If you ever figure out how to filter for a range of dates then I'd be really happy. This would be helpful in filtering and rolling up amounts by calendar month for T12 reports. The ultimate solution is for Airtable to further develop the filters for the date field to allow the use of formulas. There are some creative work around (using this video as an example); however, it can get a bit complicated. My solution at the moment is a field where I tag a record by the period(s) it belongs to.
Really liking your videos as I’m new to Airtable and trying to use it for inventory tracking and purchases for my Amazon business. It would be great to see a video on how to put a database together for that. Database for all products and link for all purchases of those items from different suppliers.
Is there a way to count how many values are in a rollup field. For instance if the rollup field returns strings, is there a way to count how many strings are in the rollup field? As always thanks for all your helpful tips.
The data in my tables comes from forms that are submitted. In a form question, someone may be able to choose one or all of A, B, C, D, E, F, and/or G. (These letters represent text.) I want to compare the answers and return what is a "match." Would I use a roll-up field type?
I have a question for my database: In your example, my request would be that I want to assign order 1 twice and order 2 once to a client. How does that work? Once I have assigned order 1 once in the "Orders" field, I cannot select it again. The rollup should then calculate the total in the same way as in your video, but not from three different orders, but twice from order 1 and once from order 2. How can this be implemented in Airtable? Edit: I just saw your video about making a junction table, i guess that would be necessary here then aswell right? It's a pity that you have to do it so laboriously in airtable.
Grab my *FREE TRAINING* that teaches the building blocks of automation: www.garethpronovost.com/webinar-registration 👈👈
You are a talented imparter of knowledge. I replicated your tables, followed your instructions carefully, and wow , it suddenly makes sense. Thanks!
Thanks for this Gareth!
It is sometimes tricky to summarize to my students what are Rollup fields and how they could be really useful, depending on the use case.
But now you gave us the perfect tutorial to show them!
Thanks Gareth. I come from an ERP developer background and have a comment/suggestion on your max date scenario. In many ERP softwares (such as my platform, Peoplesoft), they have tables with "effective dates" and they also have "effective status". This allows you to do a lookup of a row of data that is active and less/equal to current date. Because in some cases you have a future date for a price change for next month or something. I think a video on handling future dated lookups that allow a user to schedule a data change in the future and let their system handle it automatically would be a useful tutorial. If that already exists, ignore :). Thanks.
Ah, great suggestion! Airtable does have lookup fields that can be filtered to include specific data, so I think you could accomplish this fairly simply. Thanks for the idea 💡
Awesome! That really helped me understand
Thanks for this great video, it helped me a lot to calculate the most recent purchase price of a product.
Glad it helped!
great video as always!!!
Thanks!
Very nice example of the Lookup and Rollup Fields! I wish this video came out a couple years ago... it really solidifies how to grab information from a different table and filter the information. It highlights how Airtable can be used to track orders.
Filtering by date in Airtable can be tricky. I liked how you resolved the max date. If you ever figure out how to filter for a range of dates then I'd be really happy. This would be helpful in filtering and rolling up amounts by calendar month for T12 reports. The ultimate solution is for Airtable to further develop the filters for the date field to allow the use of formulas. There are some creative work around (using this video as an example); however, it can get a bit complicated. My solution at the moment is a field where I tag a record by the period(s) it belongs to.
Really liking your videos as I’m new to Airtable and trying to use it for inventory tracking and purchases for my Amazon business. It would be great to see a video on how to put a database together for that. Database for all products and link for all purchases of those items from different suppliers.
Thanks for the idea, I'll add it to the queue!
Do you have anything on using barcodes and the Airtable mobile app on phones for scanning for making an inventory of theater items?
Is there a way to count how many values are in a rollup field. For instance if the rollup field returns strings, is there a way to count how many strings are in the rollup field? As always thanks for all your helpful tips.
You can use a count field with the same conditions as your roll-up to get the results 👌
The data in my tables comes from forms that are submitted. In a form question, someone may be able to choose one or all of A, B, C, D, E, F, and/or G. (These letters represent text.) I want to compare the answers and return what is a "match." Would I use a roll-up field type?
How are you comparing the answers - are two form submissions being compared to one another?
I have a question for my database: In your example, my request would be that I want to assign order 1 twice and order 2 once to a client. How does that work? Once I have assigned order 1 once in the "Orders" field, I cannot select it again. The rollup should then calculate the total in the same way as in your video, but not from three different orders, but twice from order 1 and once from order 2. How can this be implemented in Airtable?
Edit: I just saw your video about making a junction table, i guess that would be necessary here then aswell right? It's a pity that you have to do it so laboriously in airtable.
Well, you might need a junction table, but you may also just want to allow linking to multiple records. This is in the settings for the table link.
@@GarethPronovost But i can not assign the same item twice in a record. In this example, i can't assign Order 1 twice in one record.