Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy

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

Topic Labels: Automations
1477 1
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

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:
Screenshot 2022-10-27 at 16.34.55
Screenshot 2022-10-27 at 16.35.15

This is the config for the automation.

Screenshot 2022-10-27 at 16.34.31
Screenshot 2022-10-27 at 16.34.39

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?

1 Reply 1

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