Virtual Not populating email template

[Rod]

I have a virtual I’m trying populate in an email template. The template sends back the correct amount of rows but doesn’t populate the cells. Here’s the virtual expression.
SELECT(TimeCards[Job Address],
AND(
([Installer]=[_THISROW].[Employee]),
([Task Date]>=[_THISROW].[Start Date]),
([Task Date]<=[_THISROW].[End Date])))

Is this common and should I create the template differently? I’m using a virtual in another template, not the same expression, but it works fine.
Thanks!

[Steve (Steve Coile)]

Please post a screenshot of the template, and a screenshot of the virtual column’s configuration screen.

[Rod]

Here you go:

[Steve (Steve Coile)]

Is the JobAddress column of the TimeCards table that table’s key column?

[Rod]

No the TimeCardID is…

[Steve (Steve Coile)]

That’s the problem. The <<Start>> tag requires a list of row references, i.e., key column values. Replace JobAddress with TimeCardID in the SELECT() expression in the virtual column’s App formula.

[Rod]

Worked! Thanks Steve!