Hello Airtable Community!
I'm working on a special project for a content calendar within Airtable. There are 4 tables in play:
The master calendar table and 2-4 tables to individually view the content being planned for each platform. The master calendar is serving as a master view of ALL communications going out, but the individual tables are being used to plan the specific content. I am working on an automation that will create a new record in the corresponding individual platform views from the master calendar.
The problem I'm running into is that I would like that new record to be linked to the original record in the master calendar. So that if changes are made to the record while viewing the individual platforms, it will also change within the master calendar table. I hope this makes sense, been struggling for the past few hours. I've attached a screenshot of what the tables look like.
