Nov 10, 2021 10:47 AM
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?
Nov 13, 2021 11:36 PM
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.
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.