How to make search filters dynamically update based on user selections, avoiding empty results

Hi everyone, I’m building a video discovery platform on Softr and I’m running into a challenge with the search filters.

I need the filters to behave relationally as in:

  • When a user selects a filter (e.g. “Country”), the other filters (like Cities or Region) should automatically update to only show options based on available videos. For example, if a user chooses “United States of America” for the “Country” filter, then the only options in the “Cities” or “Region” filter should be those in the USA.
  • Right now, users can select multiple filters but they can sometimes get no results, which causes drop-off. I’m just trying to prevent users from seeing no results.

Are there any workarounds that could help me get closer to this behavior inside Softr? Or is this outside Softr’s current capabilities? Thanks!