I have an airtable base that includes a Coaches tab and a Clients tab. Coaches can have multiple Clients and coaches can share clients. How can I filter the Clients data so a logged in coach only sees clients they are linked to.
I’m using the filterByFormula, then FIND(‘User email’,{Email (from Coach)}). Unfortunately this leaves off clients where the logged in coach is listed first in the column.