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!
Solved! Go to Solution.
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.
Please post a screenshot of the template, and a screenshot of the virtual columnโs configuration screen.
Here you go:
Is the JobAddress column of the TimeCards table that tableโs key column?
No the TimeCardID isโฆ
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.
Worked! Thanks Steve!
User | Count |
---|---|
39 | |
35 | |
29 | |
23 | |
18 |