Hi, I am working on a simple Experience Builder App which allows viewers to select a state county, which then filters a list showing public service providers that operate in that county.
Many of the public service providers only serve one county, but others serve multiple counties, and some serve all counties. I want the app to work so that when a user clicks on a county in the map, the list is filtered to show all public service providers relevant to that county.
I have a map Widget and a List Widget displaying the Public Service Providers. I set up a Message Action on the map with Record Selection Changes as a Trigger, and Framework Filter for an action.
I can link County:Name to ServiceProvider:CountiesServed, but this only works for providers that only serve one county.
I see there is an SQL Expression Builder, having something like
ServiceProvider:CountiesServed CONTAINS County:Name is what I need, but I can only access Fields for the Action Data, and not the Trigger data...
This seems like it should not be difficult to achieve, but I am not seeing a way to do this. If there were more options for configuring SQL expressions, or something more complicated like bitwise math operations this would be easy.
Thanks for the help!
