Solved
Help with searches...
- i set up a report that lists each vendor and what states they checked off for service area, they are checkboxes, i don't know how to make it group all vendors that service alabama, all vendors that service alaska, all vendors that service arizona, etc...
- my ultimate goal is to create a search widget that will filter by service area
- i inherited this app and it was seriously lacking. i'm new to creating and working on app setups. i have taken the intro to app building and intro to pipelines courses so that i could make some changes and i just can't figure this out.
np,
just make a formula field of type formula multi select.
use a syntax like this.
Formula Multi Select Text
Split(List(";",
If([Chocolate], "Chocolate"),
If([Vanilla], "Vanilla"),
If([Strawberry], "Strawberry")))Then include that field as a Dynamic Filter on the report configuration. It will offer up a drop down list of all your states.
