Virtual Not populating email template

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!

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

Here you go:

1 Like

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

No the TimeCardID is…

1 Like

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.

3 Likes

Worked! Thanks Steve!

1 Like