Easy Tech TutsHow to Automatically Link Records With Airtable Automation Easily 2026
By Impran M N
Manually linking related records across Airtable tables gets tedious fast, but an Automation combining a trigger, a Find Records step, and an Update Record action can do the matching for you. This guide walks through building that workflow so new or unlinked rows connect to their matching record automatically.
01Set up your linked record fields first
Make sure the tables you want to connect already have a Link to Another Record field configured between them.
02Create a new automation
Go to the Automations tab and start a new custom workflow.
03Configure the trigger
Set up a "When a record matches conditions" trigger to detect incoming rows that don't yet have a linked record.
04Add a Find Records action
Add a Find Records step to search your target table for a record matching a dynamic identifier, like a shared ID or name field.
05Add an Update Record action
Use an Update Record step to push the found record's ID into your linked field, completing the connection.
06Test and turn the automation on
Run a live test to confirm records link correctly, then toggle the automation on to let it run automatically going forward.
Frequently asked questions
Do I need to already have a Link field set up before building this automation?
Yes, the Link to Another Record field needs to exist on the table first — the automation fills it in, but doesn't create the field itself.
What if Find Records returns more than one match?
You'll need to add logic or a more specific matching condition, since the Update Record step expects a single record reference.
Can this automation run on every new record automatically?
Yes, once the trigger is set to watch for matching conditions and the automation is toggled on, it runs on qualifying new or updated records.
Is this beginner-friendly or does it require scripting?
It's built entirely with Airtable's no-code automation steps — no scripting is required for the basic Find and Update record flow.
Watch the full walkthrough
The same steps, demonstrated on screen from start to finish.
