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!