I have a list of venues in a Glide table. I want to be able to assign multiple Categories to each venue. I’m using a choice component to allow people to select multiple categories in order to filter the list of venues by the selected categories. The issue I’m encountering is that when a user selects multiple categories using the checkbox choice component, not all associated venues are showing up.
For example, here is my data. If I use the choice component to select Ice Skating plus another category, this venue does not show up:
I’m storing the selections in a text field then using a Single Value field as well as a Split Text field to create an array of the selections. The Category Match column to return “True” if the selected value is included in the Category column.
I also have a table of Categories with a relation to the Venues table and that is working well. What am I missing?