Filtering tables

[MattLB]

@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

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.