We have a horizontal chip list showing service categories. When a user selects a category, it should filter another list of businesses to show only those linked to the selected category.
To do this:
-
Relationships: We set up many-to-many relationships between the Service Category Collection and Business Collection because one business can have multiple categories.
-
Temporary Field: In the Users Collection, we created a temporary field called Selected Category. This field is meant to store the category the logged-in user selects from the chip list.
-
Filter Logic: We added a filter to the Business Collection list. This filter checks if the businesses are associated with the category stored in the logged-in user’s Selected Category. The filter we wanted was “Current Business Collection > Service Category > All contains Logged In User’s selected category.”
Problem: The issue is that we got the first section “Current Business Collection > Service Category”, however, we did not get Logged In User’s selected category. Note: We do not want to use 1 to many relationship because that doesn’t meet our business expectations.
