Dropdown option set for filtering

Need help Database
1

Hi everyone

I’m trying filter a repeating group based off a database item’s field, and that field is an option set.

When I set up the dropdown filter, nothing is showing up in the choices section. I was able to get it to show once somehow, but then I was not able to filter the repeating group by the dropdown as Bubble said it was incompatible data type.

On my dropdown, I’ve selected types of choices as text, the database field, and the option set field name and nothing seems to work and Bubble keeps telling me to change the data type.

For this image, the shopping categories item display is the option set. On the dropdown on the page everything is blank

bubble help 1
bubble help 1337×313 7.5 KB

If I change the type of choices to Shopping Categories (the option set) and the source is each item’s display I get an error saying it should be a text (which doesn’t work as seen above)

I’ve also tried with type of choice as text and doing a search for the database data type searching for the data field’s each item display and nothing shows up.

bubble help 2
bubble help 2344×297 7.75 KB

bubble help 3
bubble help 3270×275 4.94 KB

No idea what I’m doing wrong and why this is not working.

2

Set the type of choices to your option set.

Set the choices source to your option set’s All options.

Set the option caption to what you want to display, e.g., This option's Display.

3

Thank you so much! This worked. I also realized I was using the wrong data field when trying to filter, the naming convention I was using is close so I was using the wrong option set in the “search for” in the filter. Once I fixed that it works :slight_smile: