How to count self linked records

[Ben_Foster]

I have a table with an Employee Name and Manager fields. The Manager field is a self-referencing link to the same table using the Name field.

e.g.

| Name  | Manager (linked) |
|-------|---------|
| John  | Sally   |
| Sally | Peter   |
| Jane  | Sally   |
| Peter |         |

What I would like to do is add a count of the direct reports of each manager. I’m aware I can see this if I group by manager but I need it as a field so I can aggregate and display the count using the org chart app. For example:

| Name  | Manager | Direct Reports |
|-------|---------|----------------|
| John  | Sally   | 0              |
| Sally | Peter   | 2              |
| Jane  | Sally   | 0              |
| Peter |         | 1              |

Is it possible to do this?

[Hannah_Wiginton]

Additionally, Ben, we have a Same Table Linked Records Sync function that’s part of the On2Air Actions app. It automatically creates backlinks in the same table.

On2Air Support

Function - Single Table Linked Records Sync

Configure your On2Air Actions Function

The Actions app also includes an additional 60+ features that integrate with Airtable.

Features like creating Google Docs automatically with Airtable data, default field values, financial calculations, compare field data, Google Sheets record and table sync, and more.

Airtable

60+ On2Air Action Features - On2Air.com - Airtable

Explore the "60+ On2Air Action Features - On2Air.com" view on Airtable.