Looping through an array and comparing against another array.
I am building a search page with filters . Our sites have various facilities , I want our users to be able to filter based on these facilities . When they click the facility in the filter , it gets added to the selectedFacilities array . In my formula I 'm trying to compare this array with each sites facilities (Also an array ) . The site facilities array is passed into this formula . If any of their selected facilities are in the site facilities array , it should return true (That gets passed out to a bigger filter formula ) I cannot get this to work at all , any help looping through arrays would be greatly appreciated . ✅1Every checks if a condition is true for ALL items Glad I could help Hey , I have similar problem and can 't wrap my head around it . I have two APIs 1 . Guests (all the guest with their names , and "Group " which includes all tags split with commas (e .g . "Friday , Saturday , LauriKokkila " ) 2 . Schedule (called here Aikataulu ) that has events and each event has "Groups " that defines what people should be attending this one , again split with commas (e .g . "LauriKokkila , IlpoKokkila " ) How do I create that for the current Guest (recognised from URL ) , show all events where any of their "Group " value is one of the "Groups " value in the schedule ?