I need to filter a restaurant menu for Halal, Vegan, Vegetarian, and a few others.
I have tried this in two ways:
- Filter to Show Dishes where Dietary Restriction is Restriction of Signed In User
This works in every instance except when a user has no dietary restrictions. In that case, no dishes will show.
- Use an In-App Filter for my Dietary Restrictions Array Column
This is okay, but it performs an OR filtering when I need it to be AND. For example, if someone is Halal and Vegan they need to see only dishes that are Halal AND Vegan, where it is currently showing Halal OR Vegan.
I have switch components for each dietary restriction because someone may want to turn on/off their restrictions. I figure the solution involves some spreadsheet magic but I can’t seem to wrap my head around it. What I really need is just a “default case” to show all dishes if there are no matches in my filter.
Does anyone have any good solutions for this?