Hi I’m currently working on a project and facing a challenge with dynamically filtering relationships based on multiple group selections using an AND condition.
I have a Groups Table.
The table can have many different types of groups, for example, USA, Brazil, Spain, Prospect, Project Name A, Project Name B
I have a second table, People that has a Groups column. The relationship is many to many, so the person can have / belong to many groups.
I have create a view where I can select different groups and see only the relationships that belong to all selected groups.
The challenge is that the filtering needs to be based on an AND condition, not an OR condition.
Given the complexity of having many types of groups and numerous combinations, I’m unsure how to set up the filtering logic in Grist to achieve this.
Any help or suggestions would be greatly appreciated!