Essentially, my use case is a services directory.
I have a site I'm building as a mock-up agency / service directory to pitch to our Human Services- and I'd like the following abilities:
- Agency List (currently a list of agencies (wish I could only display individual names, not 30 of one agency because they have 30 services) that filters a map
- Services Index with categories (Filter widget with a table widget)
On the Services Index page, I'd like to have a list specified from a "Category" field in my attributes. However, I don't want every entry, I want to be able to aggregate it so that I have one entry for each category, and selecting it will filter the table below to show only those agencies that fit into that category. Even, better - it'd be great if it filtered the other pages too, but I'd like that to be a yes/ no option. I wish I could turn off the filter affecting the entire experience if needed.
Solved! Go to Solution.
Very similar, although ideally I'd like a dropdown option, as I have more then that in categories, which is part of my issue. I think I can narrow down the services using related tables, although I haven't worked out the design yet as I am running this mock-up on a test dataset of 100 records.
Thanks! That helps a lot! Do you know if there is a way to set a "default" filter? I've got tons of categories and I think it is causing my table to slow to a crawl to load them even for 100 entries. I was thinking setting a default filter would allow it to load the page faster.
If I understood it correctly, you can use Predefined Values to filter the data, this way you can select one value to be the default. However, you have to add all values one by one
Select Unique (Predefined)
Add Predefined Unique values
yes, this was just what I was asking. Looks like this is something to keep in mind if they decide to take my suggestion of moving their database out of Access and narrowing down the categories. They have 30 category columns (Category 1, Category 2, etc.) and some of them get way too precise. I'm thinking if I have each provider in a table, with a related table of services offered and a single category field for each service, that I can filter it based on the settings you showed me. I wouldn't want to do it with the 700+ service providers & categories they have now, but definitely may do this if we can get the data restructured & cleaned up.