Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Contact list with referred to/by linked

Topic Labels: Base design
Solved
Jump to Solution
263 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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?

1 Solution

Accepted Solutions

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/

See Solution in Thread

2 Replies 2

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/

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.