Airtable noob here, we are just integrating the software into our company’s workflow.
Is there a way to track or view all the times someone has been tagged as a collaborator, across all tables in a base? We currently have one table for projects and a linked table for tasks. I would like to be able to create a view where I can see all the projects AND tasks that I’ve been tagged in. Is this possible?
If you make a separate table with collaborators and use a link field in the projects and tasks tables to add them, you will have 1 field each in the collaborators table. If you add a count field to it and maybe a formula field to add things up, you’ll get what you want. But let’s see if anyone can do it more efficiently.