[Solution] Multiple checkbox filters on a Repeating Group — simpler than Daisy Chain

[ihsanzainal84]

@jeremyamigo

• Use intersect with if you want an AND logic — the result must match all checked filters simultaneously
• Use merge with if you want an OR logic — the result matches at least one of the checked filters

Here’s one of the ways I go about it in one filter:

@ihsanzainal84

In your :filtered settings, instead of just using “[List 1] intersect with [multidropdown] :count > 0” create a boolean (true or false) to detect [multidropdown]:count > 0. Then if true (yes) show filtered results, if false (no) show all results.

How does this look like? Something like this
[List 1] intersect with [multidropdown] :count >= Arbitrary Text:Converted to number

What goes into Arbitrary Text?
[multidropdown] :count > 0 :formatted as text

What goes into :formatted as text?
If Yes “1”, if No “0” (without the quotations)

Why does this work?
It sets up a conditional within your :filtered that will show all results if your [multidropdown] is empty but filters all Things in your [multidropdown] when it isn’t. So now you can have complex live filtering without having to set up so many conditionals!

Reducing lengthy conditions to integers lets you use simple comparison operators.