Mar 09, 2023 08:29 AM
Hello!
I am trying to create a master calendar from the different bases I've created in my workspace. I began with creating a master calendar base and syncing up the other bases table to this base. I created an automation that when a new record gets created in one of those synced base a new record gets created in the master calendar table. Now I'm running into the issue that when a record is updated in one of the bases it doesn't update in the master calendar. I'm at a roadblock and have been trying to figure this out for a while now.
I'm also trying to see that when I link to a record it doesn't link to the synced base record but the actual record in the other base.
I've attached screenshots of my base and automations. I'd love to hear any feedback or suggestions, it would be much appreciated!
Thank you in advance!!
Mar 10, 2023 04:55 AM
Hm, instead of having one synced table per base, and having automations that create a record in a master calendar table, could we sync all your tables into a single table instead?
That way changes you make in those other bases would show up fine in your master calendar table
Mar 15, 2023 11:38 AM
Is it possible to do that? If so I'd love to know how!
Mar 16, 2023 01:43 AM
Yeap, here's a link to the documentation