Making a filter system

Hey everyone :waving_hand:

I’m building a homeschool app where families can find local providers, meet-ups, and co-ops.

I’ve got:

  • A main data table called Clean – Provider Responses (each row = business listing made through google sheets… Is Excel better?).
  • A Filters State table (to hold user-selected filters).
  • A Filter Options – Age Ranges table (lists 0–4 years, 5–8 years, 9–12 years, 13–18 years, etc.).

Here’s what I’m trying to do:
User goes to a Filters page, selects an age range (and later cost, suburb, etc.).
Then they tap “Go to Map,” which shows only the providers matching those filters.
Make it like a car sales app where you can specify exactly what your looking for

I’ve tried:

  • A Choice component writing to Filters State → Pick Age Range.
  • In Clean – Provider Responses, I added:
    • User Pick Age Range (Single Value → from Filters State → Pick Age Range → First).
    • Age Match (If–Then–Else: if User Pick Age Range is empty → True; if Age Range includes User Pick Age Range → True; else False).
  • My map is filtered to show only where Age Match is True.

But currently:

  • When I apply the filter, everything disappears (no results).
  • Or the Choice component won’t let me “Write to: Filters State → Pick Age Range.”

It feels like the two tables (Filters State and Clean – Provider Responses) aren’t communicating properly.

Goal:
I just want a clean setup where:

  • A user selects filters on one page
  • Clicks “Apply Filters”
  • The Map screen updates to show only matching results.

Can anyone share the correct structure or an example app where this works?

If you can, move as much as you can to Glide Tables for performance reasons.

This does not sound correct. Can you provide some screenshots?

Your single value and if-then-else approach seems correct, but at the moment have you configured multiple options?

The below may give you some ideas.

1 Like