I have a fairly large database in a List that I’d like to sort by US States and Cities.
I’ve created an Inline Filter with a tag for each US State— that’s working great.
The problem is, I have over 1000 Cities - way too many to comfortably display on a dropdown.
I need the City Inline Filter dropdown to only show Cities that are located in the currently selected US State, and hide the rest. A “prefilter”, if you will.
(I believe this is called a Cascading or Hierarchical Filter.)
Connected with co-founder on Artur on Twitter. He said this feature is on the Q4 backlog. Also asked team member Mario, still waiting on a reply from him.
Hopefully it will get built soon! It’s a critical component of my app.
Same. It could make Softr the go-to-app for building resource/content libraries (like YC’s startup reading list), which more and more community platforms are integrating.
Related question - how do you populate the filter? Other than copying a large set of values into a filter field on a block, I don’t know what’s the right model. In a perfect world it would build a dynamic filter list based on the entries in a field (e.g. there might be 50 countries in my AT today and 53 in 2 weeks - my filter should be able to inspect Airtable and give me all of the unique options - e.g. 43).
@suzie: we are really interested in this as well, not having dynamic filtering functionality is a huge limitation today, as we would theoretically need to build separate pages for different meta categories to make the UX work