- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 20, 2025 09:14 AM
Hello - I'm fairly new to Airtable and I have a base with 5 tables, each table contains the schedule of a different project that I am tracking. I want to create an interface calendar that displays milestones across the 5 projects, but I can only see how to source from one table.
Is there a way to connect your interface to more than one table? Thank you in advance for any help!
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 20, 2025 10:24 AM - edited ‎Feb 20, 2025 10:27 AM
Short answer is you can build an interface page that spans multiple tables using the Blank page option. It'll take a bit more construction than a simple calendar page, and your tables will be contained on different calendar widgets, but it'll all be the same interface page.
If getting all the project info on to one calendar widget is the goal, you can either restructure your data so there's one project table, with each row being a project interlinked to other tables (better for long term data structure anyway probably) or you can create a junction table and use lookup fields to get all your necessary info into one table to use for an interface.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 20, 2025 10:24 AM - edited ‎Feb 20, 2025 10:27 AM
Short answer is you can build an interface page that spans multiple tables using the Blank page option. It'll take a bit more construction than a simple calendar page, and your tables will be contained on different calendar widgets, but it'll all be the same interface page.
If getting all the project info on to one calendar widget is the goal, you can either restructure your data so there's one project table, with each row being a project interlinked to other tables (better for long term data structure anyway probably) or you can create a junction table and use lookup fields to get all your necessary info into one table to use for an interface.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 20, 2025 11:37 AM - edited ‎Feb 20, 2025 11:41 AM
Thank you!😀
If the data is restructured so that there is one table with each row interlinked to other tables, would the row be a roll-up of specific fields within the detailed project schedule table it is linked to? I'm not sure what this would look like - if you are able to explain further I would be very appreciative.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 20, 2025 03:19 PM
In an ideal world, you'd have all 5 of your projects in the same table, one for each row, with fields for title, description, start/end date, etc. Then you'd have a linked record field to a new table for "Tasks" or something similar, which breaks down the project into constituent parts. Then you can use lookup or rollup fields to move the data from Tasks into Projects, and map it to a calendar view. There are several project management templates Airtable has that break down like this.
From that general concept, you can make modifications. If your projects aren't start/end, but full of recurring tasks, you can set up your task table differently etc. Now if your projects are vastly different with large datasets (analytics tracking vs marketing material creation, etc) then perhaps multiple tables or bases is the right approach, but usually you want to gather like together.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 21, 2025 08:51 AM
Thank you, @DisraeliGears01 . This makes sense. I do have a Project table that is linked to each schedules end date, and I had planned on adding more roll-up items as the schedules are created, but the projects are different enough that they, unfortunately, may need to be on separate tables.
I appreciate your time and expertise!!!
