- 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.
Solved
Help with searches...
Best answer by MarkShnierYou
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.
+22np,
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.
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.