Skip to main content

Hi all,

I’m trying to set up a self-linking “Related Records” field in Airtable (Team license) so that when I link one record to another, the linked record automatically shows the same relationship in return, within a single field.

Right now I have:

  • A Related Records linked-record field (self-linking within the same table)

  • Airtable’s automatic “From field: Related Records” mirror field, which shows the reciprocal links

Functionally this works, but the relationships appear split across two fields.
My goal is to have all related records appear together in one field, even if that means creating a new combined field.

I’ve tried to figure out if a formula or automation could merge the two linked-record lists into a single multi-value linked field, but haven’t found a way that works.

Has anyone successfully combined self-links and their reciprocal “from field” values into one linked-record field?
If so, could you share how you set it up (automation, script, or other workaround)?

Thanks!

Does this look right?  If so I’ve set it up here for you to check out

Idea is to have an automation that triggers whenever the ‘From’ field is updated, and its action will be to update the original linked field by combining the data together:

And if there isn’t already a value in the ‘From’ field then it’ll just paste it in:

 

Terms & ConditionsAccessibility statement