Help

Re: Automatically populating linked records

Solved
Jump to Solution
4942 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Elizabeth_Murna
4 - Data Explorer
4 - Data Explorer

New Airtable user here, so this is a pretty basic question (and so hopefully a straightforward answer!), though I can’t find existing guidance in the forum.

Specifically, I’m having no luck creating a “Link to another record” column that automatically populates itself with those linked records.

The Project tracker template provides an example of exactly what I mean: the Task column is linked to the Tasks table and automatically fills with any new records that are added to the latter.

When I attempt to create a new “Link to another record” column with this functionality, however, it’s blank and stays blank (doesn’t pull in existing or newly created records from the Tasks table).
ss

What am I missing? Do I also need to create an automation, app, or something else to do the work of pulling in the records? (I don’t see any such automation or app in the template though).

Any guidance extremely appreciated - thank you!

1 Solution

Accepted Solutions
Kevin_DiBenedet
6 - Interface Innovator
6 - Interface Innovator

I have been trying to build an automation that attempts to link records that are now being synced into my base from another base. My new table primary field is a student’s name. It is attempting to match a primary field from my main table which is also the student’s name. This has proven to be successful when the student’s name matches. It fails when the student has a nickname or uses a middle name. Makes sense since the primary fields don’t match.

What I wanted to try and build in the automation was to match and link based on a unique email address that exists in both tables. I can’t tell if this just isn’t possible, or whether I’m not setting up or understanding the limitations of the Automation tab.

Any ideas would be appreciated!!

See Solution in Thread

6 Replies 6
ScottWorld
18 - Pluto
18 - Pluto

Welcome to the community, @Elizabeth_Murnane!

In Airtable, you have to manually link records -- but you can do this through an automation, if you'd like.

Here are some options for linking:

1. You can use Airtable's Automations to automatically link records in Airtable.

2. If you already have a large set of records that you need to link, you can do a one-time-only linking of your records by converting a text field (in table #2) into a linked record field that links to records (in table #1).

3. You can turn to Make's Airtable automations & integrations to do automatic linking for you. Make is a no-code automation platform that gives you tons of customizability & tons of power that Airtable doesn't natively give you.

p.s. If you have a budget for your project and you’d like to hire an expert Airtable consultant to help you with any of this, please feel free to contact me through my website: Airtable consulting — ScottWorld 

Got it — thanks for confirming and for that tip!

Kevin_DiBenedet
6 - Interface Innovator
6 - Interface Innovator

I have been trying to build an automation that attempts to link records that are now being synced into my base from another base. My new table primary field is a student’s name. It is attempting to match a primary field from my main table which is also the student’s name. This has proven to be successful when the student’s name matches. It fails when the student has a nickname or uses a middle name. Makes sense since the primary fields don’t match.

What I wanted to try and build in the automation was to match and link based on a unique email address that exists in both tables. I can’t tell if this just isn’t possible, or whether I’m not setting up or understanding the limitations of the Automation tab.

Any ideas would be appreciated!!

@Kevin_DiBenedetto Unlike most other database systems, Airtable doesn’t let you link records based on the values of fields.

Because of that, you can only match to an entire record, which is designated by its primary field.

Since the email address is not the primary field, you would need to figure out what the primary field value is for the record that has the email address you’re looking for. Once you have the primary field value, then you can link the records to each other.

If you need to search for the records before linking, you can do this with Airtable's automations, but there are some limits you might hit against when searching with Airtable's automations, so I would typically recommend doing all of this with Make's Airtable automations.

p.s. If you have a budget for your project and you’d like to hire an expert Airtable consultant to help you with any of this, please feel free to contact me through my website: Airtable consulting — ScottWorld 

Thanks ScottWorld, that worked for me where endless Airtable videos failed!
But given the amazing functionality of Airtable, I’m surprised that you can’t look up a record entry via a common linking entry (other than a one-off via the primary field). I have linked my tables, but every new record in the first table needs to be manually linked to the second to look up the linked data :frowning: . Is this really true?

Thanks @ScottWorld - this solved the problem I had as a new user of airtable.

For others who may need a pointer, the support article "Converting existing fields to Airtable linked records" was where I found details on how to do this (in particular the section "Linking existing tables of related records in Airtable").