We are using Airtable as a task manager to keep track of to dos. Each of the four employees at our company has a sheet in the ‘task manager’ base and each sheet has a ‘Collaborator’ column. I want to create a sheet/view that could show me all of the records in the my coworkers sheets on which I am a collaborator. To be clear, this should be real time so that whenever one of my coworkers creates a record where i’m a collaborator, that record appears in my view/lookup/search. I’ve been trying to get this to happen by using linking & lookup fields but to no avail. Is what I am trying to do possible?
Thanks!