Count of linked records across all records

[Michael_Bevilac]

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?

[Justin_Barrett]

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.

New Script: Same Table Linked Records Backlinks Scripting app

Explainer Video: Base: Code:

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.