Forum Discussion

elisajones's avatar
elisajones
Registered
6 hours ago

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.
create search

1 Reply

  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    6 hours ago

    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.