Filter Repeating Group using Multiple Options/ Multi Dropdown?

Need help
1

Hello Bubble Community.

I have three tables in database named “Menu”, “Menu Items” and “Ingredients”. The relationship between them is such that each “Menu” has multiple “Menu Items” and each “Menu Item” has multiple “Ingredients”.

On the Front Side, I have put a Repeating group on page that shows “Menu Items” for a specific “Menu” stored in database.

Now what I am looking to do is to filter the “Menu Items” that are being shown in Repeating Group on the basis of multiple “Ingredients”. For Example, I don’t want to see the “Menu Items” that contain “Ingredients” such as Wheat, Sugar, Oil, Cheese etc. I am trying to do it using a Multidropdown whose “Type of Choices” is set to “Ingredients” but because of multiple choices, I cannot perform this action.

1
1758×590 108 KB

What approach or suitable combination should I go with to achieve this functionality. Any help or ideas in this regard would be very much appreciated.

Thanks & Regards

2

Hello @Talha54

Explore advanced filtering, contains lists, and intersect with.

These are advanced concepts. The below video should help shed some light:

2 Likes
3

@cmarchan Thanks for sharing the vide.

I get the concept of “contains list” but what I want to do is actually to remove “Menu Items” from RG that contain multiple “Ingredients” selected though the Multidropdown. I wanna do “doesn’t contain list” kind of thing actually.

Also I have tried “Intersect with” but it hides data altogether and only shows data common in both RG and Multidropdown otherwise RG gets shown empty.

It is easier to do “Advanced: This Menu Item doesn’t contain Dropdown’ (Single) value” but when we have a Multidropdown where multiple values are being selected, that’s when the problem arises.

4

note you can use minus list in combination with states.

eg Do a search for X: minus list multidropdowns values.

1 Like
5

This topic was automatically closed after 70 days. New replies are no longer allowed.