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?
Count of linked records across all records
+21Welcome 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.
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.