I am new to Bubble and I am struggling to filter a repeating group using two multiselect dropdowns. I would like to make multiple selections in each multiselect dropdown, which would filter the repeating group accordingly. Here are some screenshots of my app to help:
I would greatly appreciate any help solving this issue and I am a visual learner, so screenshots of what to do are very helpful. Thank you for your time and help!
Hey @fayewatson I’ve read some of your posts on filtering repeating groups using multiselect dropdowns and was wondering if you could provide any advice for solving this issue. Thank you for your time and consideration.
You’ll need to share how you’ve set up the constraints/filters and/or conditionals on the repeating group for anyone to help. Screenshots will be best.
Hey @foraanyas thank you so much for your reply. Unfortunately, I cannot seem to make the same selections as you do in your video. Could it be related to differences in the data we use? Here are some screenshots of my data types and app data.
Hey @foraanyas Thank you for helping me attempt to solve this issue. I tried making the same filter selections as you did in the video you sent me, however at 3:46 in the video you make a selection for “intersect with”. This option was not available for me. I took a screen shot of this issue and was wondering if you had any ideas on why “intersect with” is not an option.
@cwd, the intersect with operator is used to compare two lists and return the items that are in both lists. Your Household Language field is a text field, so you won’t see the intersect with operator because that field is not a list field, and it can’t be compared to another list field. Is the Household Language field supposed to be a list?
Okay, then you can’t use the intersect with operator. I assume you just want to see if the list of languages selected in the multi-dropdown contains the value in the Household Language field?
Correct. The Household Language field contains observations (languages spoken) for each state and I would like the user to be able to select one of these and filter the data table ‘LanguageData’
I’ve been trying to follow this other helpful video by @zubair_nocodehttps://www.youtube.com/watch?v=7kCi0p8l_vU but I have not been able to make the :count selection as they have done at 1:29. The way they are filtering seems to be how I should do it.
You can’t use intersect with and you can’t do a count because you are not comparing two lists fields. Try building your expression the other way around… see if the multi-dropdown’s value contains the Household Laguage's value.
Hey @mikeloc Thank you so much for you help as I’m getting close to figuring this out. I am finally able to filter my data table for stats on languages spoken in each state by making selections in both multiselect dropdowns:
I know that my use of “and” results in the user having to select both dropdowns to filter the repeating group, but "or " isn’t right either. What should I try instead?
It would be nice if you could just check the box to ignore empty constraints, but that setting doesn’t work with advanced filters. So, try changing the expression to Multidropdown Search for Language's value contains This LanguageData's Household Language or Multidropdown Search for Language's value is empty. Then, add a new constraint/advanced filter with the same expression for the state multi-dropdown.
Edit: I forgot you can’t use is empty with a multi-dropdown, so you will need to use :count is 0.
Ok that worked great for showing the data in the repeating group without having to make a selection!! Thank you! Also, instead of or Multidropdown Search for Language's value is empty I used Multidropdown Search for Language's value:count is 0 because “is empty” wasn’t an option.
*Now how do you think I could include my multiselect dropdown for filtering for the States? Would starting a New constraint work or should it be in the same constraint as the language filtering?
