How do I use an automation to update one table based on a change on another table?

[Sean_Patterson]

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.

What am I doing wrong here?

[TheTimeSavingCo]

Hi Sean, I think your issue lies with the Record ID input: that needs to be a record ID value

Here’s a link to the docs that should help