Creating a field that lists what is linked to

Ask the community Base design
#1

This is a tough one to describe in one sentence. Basically, I have a group of people who “sponsor” one another. There is no real hierarchy. Person A could sponsor Person B who could sponsor Person C who could Sponsor Person A. Some Sponsors might have multiple Sponsees.

So I have one field, “Name”, and another Field “Their Sponsor” that links to the Name field. So I can see each Sponsee’s Sponsor, and what I would like is a way to see each Sponsor’s Sponsees, ideally in the same table. And, ideally, when the field “Their Sponsor” is updated, the “Sponsor’s Sponsees” field is automatically updated.

Thanks in advance.

#2

Look at us having the exact same problem at exactly the same time.

1 Like
#3

Hi @JasonF - have a look at this post - you can use Airtable Automations to make reciprocal links:

2 Likes
#4

Thank you, Jonathan. It looks like Automation is what I am looking for. I can’t quite work out a solution with automation (because the update record action doesn’t allowing adding to a record, only replacing), but I think that’s a subject for another thread.

#5

For those interested, that problem [update record action doesn’t allowing adding to a record, only replacing] has been solved :

1 Like
#6

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