Email template expression

jonbowles84 · 02-14-2022 05:34 PM

Hi People,

Im sorry for asking this as Im sure its a ridiculously simple fix, Ive tried "SELECT" and [_THISROW] and multiple other variations over the last couple of hours.
This is referencing my "Timesheet" table where I have a column [Project} which is the same as [Project Number] in the "Projects" table.
So I just want to display (Projects[Client]) and (Projects[Project]) where (Projects[Project Number]) is the same as [Project]

<<START:Projects[Project Number]>>
<<[Project Number].[Client]>>
<<[Project Number].[Project]>>
<<END>>

Any help please...🙄

I should mention, that the above expression pulls all values from Projects[Client] and Projects[Project]

Marc_Dillon

Maybe this?

<<START: FILTER( Projects , [Project Number] = [_THISROW].[Project] )>>
<<[Project]>>
<<[Client]>>
<<END>>

jonbowles84

Thankyou so much!! 😁