I have a collection of different activities such as swing classes, book club, meditation etc...
A repeater shows this different activities and I want to be able to filter it.
Each activity has some key words related to it for example "dance and music, exciting, outdoors"(this is one string in a text field of the collection)
I want to be able to filter these activities by an array of strings that can or cannot be found in the text field of the collection. (this array of strings comes from checkboxes that can be checked or unchecked and which values are pushed into this array)
Activity "yoga" keywords "quiet, outdoors, relaxing"
Activity "swing" keywords "dance and music, exciting, outdoors"...
FilterArray1 = ["outdoors", "quiet"]
results would be item "yoga"
results would be both items "yoga" and "swing"
I also tried doing this with multiple reference fields so either solution would be fine! Thank you