I have a list of people and a list of projects. Each person can be member of several projects. Every person should see only people working on the same project
John working on A and B
Bob working on B and C
Julie working on C
John should see himself and Bob
Bob should see all three
Julie should see herself and Bob
Can you give me a condition for this?
I don’t think this can be done purely as a condition I think it’s just a bit more complicated. I have set up an example with your data. I’ve than added a formula column for each person that calculates their coworker and have set up access rules according to that.
A template with the formula and all the rules is available at
https://docs.getgrist.com/7aVz4aE1oPCp/People-and-projects?utm_id=share-doc
There are two possible downsides with the approach. One is that there is that aditional coworkers column, but I think that might actually be useful for other later uses as well, and besides you can always hide it if you really don’t want to see it.
The other possible downside is that in this case Julie can see Bob (that’s fine) and she can also see that Bob is working on project B which she doesn’t have access to. If this is a problem there are ways that this could be hidden as well but we can work on that later if it does turn out to be a problem.