Solved: Help with template filter expression - Page 2

Elijah_Magrane · 05-15-2019 09:24 AM

Hi I am trying to create a template expression that would return the weekly timesheets back to the user. I have a parent Employee table and the child employee table.

The starting expression I need to filter is this…<<Start: [Related Timesheets [Name]]>>

This use case is pretty common but I am troubling with my expression. This is what I have so far…

<<Start: SELECT([Related Timesheets][Name], AND(IN[NAME],[THISROW].[Related Timesheets]),[Date]>=TODAY()-7))>>

Any help would be appreciated

Elijah_Magrane

It was a syntax issue. I had to rename the ref column. Thanks the final expression was…<<Start: SELECT([Related Timesheets][Timestamp],AND(IN([Timestamp],[_THISROW].[Related Timesheets]),[WeekNum]=[Current WeekNum]))>>

View solution in original post