Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Nov 19, 2023 12:23 PM
What would be the most practical way to incorporate multiple tables worth of calendars into one? In an interface, to be specific.
I have three tables worth of data I'd like to mix together in a single calendar. I suppose I could have them all in one table, but I'm concerned it might make things a bit busy in that main table.
I have Table 1 that is basically like a CRM for any incoming proposal requests for my business and I have a few date fields there. 3 sets of start and end dates to cover dates we'd hold for the client.
Then I have Table 2 where we actually schedule specific events. Just a start date (with a time) and an end date (with a time) for a specific event stemming from an approved project in Table 1. 1 entry in Table 1 could have 20 events in Table 2, mind you. But every Table 2 event is linked to an entry in Table 1, so there's already a natural link there.
Table 3, on the other hand, is less connected to Table 1 and 2. This is just a calendar of relevant events that might impact our operations (like if there's a major concert next door, we'd want to know this to avoid schedule an event next to a Taylor Swift concert) or holidays where we close the office. We also use this table to have employees request time off and we can see that there.
So I'd love to see all three things at the same time. Table 1's potential date ranges. Table 2's actual event dates and times. Table 3's relevant other dates.
Not sure how to bring it all together though. Also relevantly, I'm pushing up against record limits in this base, so I'm not averse to something like making a new base and syncing these three tables to play with over in the new base purely for calendar purposes.
Any ideas are appreciated!
Solved! Go to Solution.
Nov 19, 2023 04:35 PM - edited Apr 03, 2024 08:30 AM
No, your 3 existing tables would all feed into a 4th table that you will need to setup.
This article might help you:
https://support.airtable.com/docs/multi-source-syncing
p.s. If your company has a budget for your project and you’d like to hire an expert Airtable consultant to help you with any of this, please feel free to contact me through my website: Airtable consultant — ScottWorld
Nov 19, 2023 01:04 PM - edited Apr 03, 2024 08:30 AM
A few ideas here:
1. You can use @Kamille_Parks's Master Calendar extension to show you events from different tables combined together onto one calendar.
2. If you are on a Business Plan or Enterprise Plan, you can take all 3 tables and sync them into a unified destination table somewhere else. Then, you can create a calendar view from that destination table.
3. You can sync all of your different calendar views to an external calendar app, such as BusyCal for Mac or Outlook for PC. (Google Calendar won't really work for this because Google Calendar only refreshes external calendars every 24 hours.)
p.s. If your company has a budget for your project and you’d like to hire an expert Airtable consultant to help you with any of this, please feel free to contact me through my website: Airtable consultant — ScottWorld
Nov 19, 2023 01:38 PM
Thanks for the options!
I'm leaning toward #2 (I'm on a business plan)
When syncing, can I sync three tables into one destination? Or would it look more like making a new base, syncing each table to its own table in that base, and then making a 4th table to unify them all?
Nov 19, 2023 02:04 PM - edited Nov 19, 2023 02:04 PM
Airtable requires it to be a different base.
Nov 19, 2023 02:16 PM
So would the new base look like, roughly (with 4 total new tables):
Table 1 Sync
Table 2 Sync
Table 3 Sync
Tables 1/2/3 Combined from Sync Tables
Nov 19, 2023 04:35 PM - edited Apr 03, 2024 08:30 AM
No, your 3 existing tables would all feed into a 4th table that you will need to setup.
This article might help you:
https://support.airtable.com/docs/multi-source-syncing
p.s. If your company has a budget for your project and you’d like to hire an expert Airtable consultant to help you with any of this, please feel free to contact me through my website: Airtable consultant — ScottWorld
Nov 19, 2023 04:57 PM
Perfect, thanks! Never done a multi-source sync despite plenty of syncing, so I didn’t even realize that was a thing.
Appreciate the help!