Filter database results by multiple checkboxes

Ask the community
,
1

I read through few posts about checkbox filters but there are no clear answer for this
I have a database like this:

972×131 3.79 KB

and I want to filter the result where the checkbox is ticked
How exactly do I do this? I’m not that experienced with wix-code so if I can have some sample code, that will be awesome
This is the form to enter those values, each of the check boxes are connected to different columns:

Thanks

2

Hey there L,

I would recommend starting off with the article How to Use Code to Let Your Users Search a Collection . This will give you a good start on how to query a database with filters (conditions).

You can then look at the setFilter() API for more details on how to build a filter with different conditions.

Good luck,

Yisrael

3

Hi All,

I had a similar requirement for multiple checkbox filters. If anyone needs help, you can check out this website for the sample code and tutorial for checkbox filters .

Cheers, Ben

4

hi your link is good thanks for that but i would like results to be displayed on a table with products listed all in the first row and the suppliers in the first column, the remaining cells display the different prices

thanks