# Filtering tables

**URL:** <https://community.glideapps.com/t/filtering-tables/42411>\
**Category:** Ask for Help\
**Created:** [May 26, 2022, 6:10pm UTC](https://community.glideapps.com/t/filtering-tables/42411 "2022-05-26T18:10:19Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![MattLB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattlb/32/41284_2.png) [@MattLB](https://community.glideapps.com/u/MattLB)\
**Post date:** [May 26, 2022, 6:28pm UTC](https://community.glideapps.com/t/filtering-tables/42411/2 "2022-05-26T18:28:03Z")

</div>

@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 two columns to 4 different tables highlights the complexity of implementing multiple filters.

Unless I am missing a more generalized and simple technique - which I am not discounting!

Here is one of example of the topic with good techniques/ideas:

> [@Conditional Rollup within Glide data editor](https://community.glideapps.com/t/conditional-rollup-within-glide-data-editor/9415/7):
>
> In your log sheet create an if then column and fill it with true if the log has a meter reading greater than zero. Then create a template that joins the machine ID and the if then value. In your machine sheet, create a template of machine ID and the word ‘true’. Now change your relation to use those templates to link machine to log. Your rollup should then show the max date of a log that has a meter reading.

---

_[View the full topic](https://community.glideapps.com/t/filtering-tables/42411)._
