Count of linked records across all records

Topic Labels: Base design
903 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I have a table of employee records with one field being a link to the manager record. Id like to count the number of employees that a manager manages. How do I do that?

Screen Shot 2022-01-14 at 11.58.07 AM
Screen Shot 2022-01-14 at 11.58.14 AM

1 Reply 1

Welcome to the community, @Michael_Bevilacqua! :grinning_face_with_big_eyes: Unfortunately Airtable doesn’t make this easy. When adding a linked record field in one table, the target table also gets a reciprocal link field added automatically, and links from A to B can be seen from either end. When linking in the same table, though, reciprocal links aren’t made automatically.

Check out this post by @openside, which includes a script that you can use to create those reciprocal links.

With those links in place, you will then have Bob linked to the three employees that he manages, and {DirectReportsCount} can be a count field to count those links.