Looking for recursive link

Hello

When building a simple base of entities (Let’s say Peter, Paul & Jack), i add a column to indicate there’s a link between two (or more) of them. Doing this, i use a Link to another Record in the same base.

So when i’m linking Paul to Peter, i see Peter in the “link” column of Paul.

But no link appears with Paul appearing in the Peter entry.

Screenshot_2021-04-16 D S ESS TEST - Airtable

Is there a way to link two entries in a simple bidirectional way ? It sounds so pretty simple, i can’t believe i have to do it twice for each link between entries.

Or should i use a graph tool instead of Airtable maybe for this kind of analysis ?

Regards,
A

Welcome to the community, @Arnaud_Merle!

Unfortunately, this is one of the current missing features in Airtable.

Airtable automatically creates the recursive link for you when you link to ANOTHER table, but as soon as you try to link to THE SAME table, you don’t get any recursive links.

The first thing to do would be to email support@airtable.com and let them know how important this feature is to you. The more they hear from us, the more hope there is that they will address this issue.

Secondly, you can automate this with a JavaScript. There are several different JavaScripts floating around out there that you could modify for your needs. Here’s one of them, created by Dan at @openside: Same Table Linked Records Backlinks | BuiltOnAir

Alternatively, you can also automate this with Integromat, which is a no-code automation platform.

1 Like

Thank you very much for your time and this useful answer !

A

1 Like

You’re welcome! Glad I could help! :slight_smile:

@Arnaud_Merle - you can also use an Airtable automation to create the reverse link - have a look at this post which is on the same/similar topic:

1 Like

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.