
Announcements
Hello internet family.
I'm working on building an app for product search based on a multichoice column. My issue is I only want to show products that contain ALL the selected filters.
i.e. Product A is XYZ, Product B is XY. I only want the gallery to show Product A if XYZ is selected and to show A and B if XY is selected.
I cannot find how to do this and maybe I am not looking in the right places or perhaps it cannot be done.
Editing to hopefully clarify and receive a response.
I have a list of Products: A, B, C, D in a column labeled "Title"
Each product has properties connected to them. Some overlap and some do not. These are selected in a choice column.
A - brown, fluffy, cute
B - brown, prickly, mean
C - Green, fluffy, cute
D - Blue, mellow, fluffy
I want users to be able to select the properties in a combobox checkbox select and for the proper products to show up only if their properties match all selected.
User selects: fluffy and cute
Gallery shows: A and C because both have fluffy and cute as properties. The gallery will not show D because it only contains fluffy.
User selects: fluffy
Gallery shows A, C, and D
User selects: fluffy and mean
Gallery shows nothing or message that says no matches.
The other question I had is, is it possible to filter Products by an identifier like the above example without the identifier being shown in the gallery? Using the example above, the gallery would filter the same way, but XYZ will not be listed in a text box.
Thank you!