Contact list with referred to/by linked

[Alexander_Golds]

I have a contact list where one of the fields is “Referred to…” to show how I got into contact with someone. What I want is a two-way link for “Referred to/by”, like so:

   Name   | Referred To | Referred By
---------------------------------------
    Jim   |     Amy     |  
    Amy   |             |   Jim
    Bob   |             |

For example, if we have three names in the table, eg.

Jim
Amy
Bob

Jim introduced me to Amy, so have it as

Jim | Amy
Amy
Bob

The problem is, when I link Jim to Amy, I want another column that shows that same relationship in reverse, a “referred by…” field. So it would look like:

   Name   | Referred To | Referred By
---------------------------------------
    Jim   |     Amy     |  
    Amy   |             |   Jim
    Bob   |             |

So far, I’ve been unsuccessful at doing this. I’ve tried using Lookup but it only finds itself.

Any ideas?

[ScottWorld · Accepted solution]

The feature you’re looking for doesn’t exist in Airtable, although everybody has been wanting it for years. Please be sure to email support@airtable.com to ask them to please add this feature into the product.

In the meantime, you can use this script created by @openside:

https://builtonair.com/script/same-table-linked-records-backlinks/

[Alexander_Golds]

I guess that’s a “solution”, but it’s not really what I was hoping for. Free plan doesn’t allow for scripting, I believe. Bummer. I emailed them about it. Thank you for the help.