Count of linked records across all records

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?

Welcome to the community, @Michael_Bevilacqua! :smiley: 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.

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