Using more than 2 "and" statements to filter data in repeating group


I am using 4 drop down fields as filters on a repeating group.

I have set up conditions on the repeating group.

The filters work independently, and are fine when using 2 of the drop down fields to filter with, but once i introduce a third filter the data is not updated.

Has anyone had a similar experience?

Below is the filters set up:

Condition for a single filter being applied:
Screen Shot 2021-01-28 at 7.51.26 am
Screen Shot 2021-01-28 at 7.51.46 am

Conditions when all filters applied:
Screen Shot 2021-01-28 at 7.52.04 am
Screen Shot 2021-01-28 at 7.52.13 am

There are 15 conditions to cater for each variation of the filters being applied.

Am i missing something?

Any help appreciated.


Curious why you are taking this approach, instead of just putting all your conditions in the “Do a search for” box. Simpler approach and would run server side – much faster and more scalable.

In terms of your particular issue, could be due to how Bubble evaluates formulas. When you have a lot of conditions bunched together it can cause an issue if Bubble is reading the formula differently than you intended.

@ed727 When you say do a search for, how do you mean?

Would you add all the constraints and check the ignore empty constraints check box?

I mean in the RG’s “Data source”, choosing “Do a search for” and filling out the constraints in that box. And yes, check ignore empty constraints. This will run server side. You want to avoid “:filter” except if it’s absolutely necessary (like an advanced filter needed to search a list based on a list), or if your data set is small, since it runs client side.

Hi Ed

Thanks for the advice, I’ll have a go.

The reason behind setting up as i have is inexperience, it made sense at the time as the filter set has built out from 1 option to 4.