- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 24, 2020 09:40 PM
Hi all - I’m new to Airtable, we use it at the Transportation Authority I work for. What I am looking to do is create a database of bus schedules by their shipping quantities (amount). Most schedules are distributed to multiple locations, which I have a table for each. Quantities of schedules per route vary from location to location. I am trying to get the total quantity of each schedule - across all tables - to the Total page, where I can view the grand total quantity per route.
I thought I was able to use the rollup feature, but I cannot get it to link multiple columns to provide me with the outcome I am looking for. Maybe I need a formula?
Any assistance is greatly appreciated. Thank you in advance!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 24, 2020 11:48 PM
HI @John_Semerjian,
Welcome to Airtable Community ! :grinning_face_with_big_eyes:
You cannot Rollup data from Multiple tables. I don’t think the best option for you is to have a separate table for each location. How about you put all the data in one table and you use the Group By option to separate the locations?
BR,
Mo
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 25, 2020 09:25 AM
Thank you for the reply!
Your suggestion makes complete sense - I’m going to do that!
Thank you,
John