Help

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

1202 0
cancel
Showing results for 
Search instead for 
Did you mean: 
AaronB
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
stevendasilva
6 - Interface Innovator
6 - Interface Innovator

Hello!

Please see the video here:
https://www.loom.com/share/e4eed15b3cfb42569a899fc2816c8e03

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.