Multi dropdown for filtering results

[Kampong]

I have a database of residential units. Each residential unit row in the database is described by: a Town, a Street, a Floor, a Price.

I would like a user of my website to be able to choose 3 floors (e.g. Floor1, Floor2 and Floor3) from a multi dropdown and be displayed residential units situated on Floor1, Floor2 and Floor3.

I installed Bubble’s Multi Dropdown plugin, thinking it can easily achieve what I intended.

Tried many times - it cannot be easily set up as a constraint in the form of:
— Search for Properties (constraint: Floor contains Multidropdown’s value). Done this way, only Properties corresponding to one Floor is displayed even though the user have selected three Floors.

Pls help. Thank you.

[tylerboodman]

Does it let you do constraint: Floor is in Multidropdown’s value

This would check if the specific Unit’s Floor (single item) is in the list of Floors (multidropdown value)

[Kampong]

Thanks all for your quick proposed solutions. Unfortunately, they do not work.

Here are the results when I use “Constraint” based on “Contains”.

• When I choose Storey “07 to 09”, residential units of “07 to 09” are displayed.
• When I choose Storey “04 to 06”, residential units of “04 to 06” are displayed.
• When I choose Storey “07 to 09” and “04 to 06”, I got an empty Table.

My setup is a Table and not a Repeating Group, I am unable to find a “is in”. Setup pics further below.

Thanks much for all your help.