Hi. I have a collection with 11 records called “food restriction”. I have another collection called “restaurants”.
I made a property under restaurants that creates a many to many relationship between the two collections.
I am trying to figure out a way to have a filter page that allows you to multi filter (AND filtering, not OR filtering) with the records in the food restriction collection.
Ex: If the records in the food restriction collection are “Soy, Dairy, Fish, Peanuts” then I want my user to be able to select Dairy and Fish. Then the restaurant collection results would only show results that BOTH meet dairy and fish.
Is this possible in Adalo / does anyone know how to do this?
I know you can multi filter between two different lists but I haven’t found any information on how to filter within the SAME list.