In-app filter doesn't require "match multiple"

[Darren_Murphy]

Okay, what you are looking for will definitely be possible, although without a deeper understanding of how your app is setup I can’t really provide specific advice.

Here is another approach that I often use for dynamic filtering, which might be applicable in your case:

Array to array relation with AND condition

I generally use a combination of templates and multi-relations for this type of dynamic filtering. The basic idea is: In the table that contains your source data, create a template column that concatenates each of the values that you’ll be filtering on. In your example, it might look something like: House:5 BR:3 WC Apartment:1 BR:1 WC Condo:3 BR:2 WC etc.. Next create an identical template that concatenates the same values from your User Specific Columns Finally, create a multi-relation tha…