Dynamic Filtering by end user

Hello,

I’m looking to replicate the advanced filtering options as per the below (from Xero software). It is also similar to constraints that Bubble has in their Data tab.
Is creating something like this possible for an end user to do advanced filtering?
Thanks!

HI, @alan.mackintosh1

Yes, that is possible to create that advanced filtering on bubble.

you can use custom state and Url parameter to keep that data and send it to RG list.

Hi,

Thanks for your response. I’m specifically struggling with the middle dropdown for “is” or “is not”, i can’t find a way of dynamically doing that in the :filter section of the search?

Okay,
Contraints:
if the dropdown is “is”
Type = Spend money
if its “is not”
Type <> Spend money, it means not including

Is that make sense or are you using an advanced:?
image