@JackVaughan @david I have been working in the Glide builder for two months developing an App based on my experiences in high tech sales. Working within the confines of Glide has been rewarding and challenging - but one capability that is a roadblock is reporting. Many people want actionable dat…

@Jeff_Hager @Robert_Petitto and others have suggested the use of templated fields and ITE logic to create ‘filters’. I am using this technique along with row-owners and roles to ‘filter’ data in a seemingly straightforward manner for the end-user but the ‘behind the scenes’ addition of a dozen or tw…

Yes, it’s one of our most requested features from intermediate users–Conditional Relations / Filtering. We’re doing a lot of architecture work on Glide Apps this quarter, to make it easier for us to bring improved filtering to columns.

[image] MattLB: If their is a Glide recommended technique to filter tables by multiple columns and then apply roll-ups - I can not find it. So any pointers welcome Well, here you can see and test another technique, it’s what I use in cases like yours Multi Filters using Relations: a new way 💡 …

Too late for a wish list? Front of the filtering queue (top of the pile?) should be filtering by dates against a range. If a date falls between a range ( start/end ) would enable reporting for week/month/quarter/year actions and items.

Completely agree. To create filters it requires MANY additional columns in the data editor: Template columns to create key values ITE columns to create the conditions User specific columns to house the user selection more ITE columns to determine if the user selections meet the conditions Relation…

Watched the video - looks great. Now time to look at your App - thanks for getting back to me. Glide can be fantastic and fantastically frustrating. More of the former though.

[image] MattLB: Many people want actionable data which means roll-ups and analytics. The current roll-up is a good start but the inability to filter data in a relation is very problematic. I need to be able to slice and dice data to compare against different reporting periods and different parts…

Great, great example. You, @Robert_Petitto , @gvalero , @Jeff_Hager and @ThinhDinh (plus others) have been invaluable with tips, ideas and practical Glide examples (how to think in Glide!). Documentation is light but user experience is rich. How did you create the inline table comparing year over y…

[image] MattLB: How did you create the inline table comparing year over year? I am assuming this css/rich text and NOT built into Glide.

After watching this video a third time I realize this is exactly what I am trying to achieve. I would have 3-4 different monthly summaries (mostly count) and an “overall” roll-up of all the details Everything I am rolling up is by ‘grouped’ by date with a ‘location’ as a filter (Southwest, Northwe…

Filtering tables

Ask for Help

Darren_Murphy May 27, 2022, 2:02pm 13

Actually, I just remembered that I did a tutorial on this a while back, that goes through the entire process step by step. This includes applying dynamic filters to the table, as well as (static) sorting.

Topic		Replies	Views
Multi Filters using Relations: a new way 💡 Ask for Help	29	3651	May 6, 2025
Filtering column using conditions Feature Requests	18	1206	July 23, 2020
Filtering data based on month from Multiple columns Ask for Help	18	414	January 25, 2024
Relation Filter Ask for Help	3	28	January 5, 2026
Show sum of numbers after multiple filtering Ask for Help	10	1266	April 5, 2023

Filtering tables

Related topics