Frontend/Client Facing filter with AND not OR logic?

Ask the community
1

I have 400 plus records (fitness exercises) that I’d like people to be able to search through to find specific kinds od exercises. In Airtable I have several single select, multiple select, checkboxes, etc that help me filter and find them on Airtable. However in Softr, the front end search for my users seems to only allow “OR” logic, and I’d like it to follow “AND” logic. Similarly to when I am configuring the data source and can decide if the criteria is AND or OR. Is this possible to do in the front end?

I have an option with difficulty, and option with equipment. So I’d like people to be able to filter for “level 1” exercises with “dumbells” for “arms”. Rather than exercises that are “level 1” or “dumbells” or “arms”. I tried to look through past posts, but I couldn’t find it; I probably missed it :slight_smile: Since it’s possible to do on the backend, I’m hoping it’s possible to have on the client facing side too :crossed_fingers:

TIA!

2

Hey @flyingbren

Unfortunately, AND logic for inline (user-facing) filters isn’t something Softr supports, and based on a previous discussion with the team, it’s not planned to be added.

The AND/OR toggle you see in the data source configuration only applies to static, builder-side filters, not the dynamic filters your users interact with on the frontend.

The workaround that may work is creating a combined field in Airtable that merges your filter dimensions into one value (e.g. “Level 1 - Dumbbells - Arms”). Users can then filter on that single field and get precise results. It takes more setup on the Airtable side and doesn’t scale as cleanly with a large number of combinations, but it’s should be the reliable option available right now.