I have a list of records which are organized by State --> County --> Polling Location
I’ve added a filter at the top which users can filter by State. But many users are not very technical and it is hard to tell them to look for the FILTER ICON. They can also use the SEARCH bar, but the process is confusing to new users and I’m hoping to simplify it.
I’d like to ask the users to choose STATE and COUNTY and then be able search from the sheet all records that match those conditions and display them. There will only be 10 states so that could be a pull down. There are lots of counties and I’d like to let the user enter the COUNTY.
Here is the app MapMyVote
The layout is simple:
STATE – COUNTY – POLLING LOCATION NAME – ADDRESS