Easy Tech TutsHow to Automatically Copy Values From One Airtable Easily 2026
By Impran M N
Keeping duplicate data in sync across two Airtable tables by hand is error-prone, but an Automation with a trigger and a Create or Update Record action can copy field values across automatically the moment something changes. This guide walks through building that workflow and testing it before turning it on live.
01Open the Automations directory
Go to the Automations tab in your base to begin building the workflow.
02Create a new workflow and define the trigger
Start a new automation and set the source table trigger, such as "When a record is updated" or "matches conditions."
03Add a Create or Update Record action
Add a new action step and choose either 'Create record' or 'Update record' depending on whether you're adding new rows or syncing existing ones.
04Select the destination table
Choose which table the action should target and begin mapping the dynamic data variables.
05Match field types carefully
Make sure field types align between the source and destination columns so the copied data lands in the correct format.
06Test, then activate
Click Test to verify seamless data transfer and output accuracy, then toggle the automation on to run it live.
Frequently asked questions
Should I use Create Record or Update Record for copying data?
Use Create Record if you want a new row added each time; use Update Record if you're syncing values into an existing linked row.
What happens if the field types don't match between tables?
Mismatched field types can cause the copy to fail or produce unexpected formatting, so it's important to verify types align before testing.
Can this automation run every time a record changes?
Yes, once the trigger condition and automation are both active, it runs automatically whenever qualifying changes occur.
Can I monitor whether the automation is working correctly over time?
Yes, Airtable keeps an automation run history you can check to confirm the workflow is executing as expected.
Watch the full walkthrough
The same steps, demonstrated on screen from start to finish.
