Dynamic permission by collaborator isn’t a built-in feature of Airtable.
If you just need the manager to VIEW the data (not edit the data), you can create different views (one for each manager) and then share the view via a share link. Share links generate read-only views that are uneditable.
You could also share that view by syncing it to another base specifically designed for that manager, which still gives the manager a read-only view, but they can add their own editable fields to keep their own personal notes. Those editable fields do not sync back to the main base.
However, for truly dynamic permission by collaborator, you would need to turn to an external solution like this one:
Stacker is another external solution, but it only syncs data from Airtable every 15 minutes, so it’s not recommended by me.
