Re: How best to create a calendar view from 3 separate tables?

543 0
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi all! 

My team has 3 tables that we use to keep track of events that have associated dates and times, including trainings, out-of-office holds, and planned travel time. I want to create a calendar view in AirTable that includes all 3 of these event types to make scheduling easier. I'm pretty sure that the only way to do this is to combine all 3 tables into a new table where I can create the views I want. What is the best way to import all of the records from those 3 separate tables into a combined table? Is there a script that I can run that will do the importing?

Once the new table is created, will I need to create automations that will ensure that if a record is created or updated in the separate tables, it will be updated in the combined table? Or is there a better way to make sure that both places stay current?

Thanks, I appreciate the help!

2 Replies 2
6 - Interface Innovator
6 - Interface Innovator


Please see the video here:

Let me know if you have any questions.

Steven Da Silva
Systems With Steve




@Kamille_Parks created an Airtable extension called Master Calendar that displays events from multiple tables on one calendar.