We keep our org chart in Airtable. It includes who Person A reports (as a link to another record) to as well as their contact info and photo.
The automation I'm trying to set up would remove the manager that Person A reports to when the manager leaves our organization. We have a status that is "No longer employed", so I'd like the automation to be triggered by that and then remove the manager from any employees they're assigned to.
I can get to a certain point, but I keep setting it up in a way that would just update the manager record rather than the folks they manage.
TIA for the help!