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!!