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.

2 Likes

Hello Darren,

I hope you have been well.

Our working situation has changed therefore making it challenging for us to create the app, hence why you haven’t heard from us.
We are thinking we may have to have further help with developing it, is this something you can help us with?

Kind regards
Taz and Dave

Will respond via PM.

Yes that works perfectly for us! Its a bit crazy this time of year! If love to chat about the concept again possibly, give a clearer image on what we are trying to achieve and then for you to clarify anything.

Anyway, enjoy your break and we will speak in 2026!

Kind regards