I have two synced tables (team 1, and team 2) pulling in dev tickets from different teams. They have the same data points.
I’ve created a third table (Joined Table) so that when a new ticket is added via the synced table it pulls it in so I have a merged view of both synced tables (essentially all tickets from both teams in one table). Using an automation. All fine.
When the fields status and/or priority in the tickets in the synced tables (team 1 & team 2) I have created an automation that updates the record in the third Joined Table. This doesn’t work and I don’t understand why.
This is screenshot of the joined-up table and Team 1 tables:
This is the config for the automation.
I have tried changing the Record ID field in the action configuration from ‘Issue Key’ to ‘Airtable Record ID’ but no luck.