New'ish to Airtable and feel like I'm running into a super'noob question and just missing something.
The point of my base is to share resources across a team, though not every resource to every user.
In my base I have a Resources table, and a Users table. Users (using a form) can share resources with SPECIFIC users and tag the resource with a number of filterable fields (like Project, Topic, etc).
I'm then using a no-code platform to display the resources shared to that specific user, and letting them filter their resources by the tagged Project, Topic, etc. To do this, I need to pull, for example, all of the Project names (multi-selects) from all of the resources shared with that user only to a single aggregating field on the User table, named for example "Projects" (which of course are all located in a single column). So in their record, they have their username, a field with all of their projects, and a field with all of the Topics they are working with.
I am trying to do this with Linked Records but it looks like each record needs to be added manually.
Is this achievable with Lookup or some kind of automation?
I feel like I'm missing something so simple here...
Thanks all!
D