I know I have done it before but I cant find the code that I did it with. I believe its a start expression but the examples I have seen still give me a line.
Here it goes, I have a VC that is named [overdue list] in a table named "Sites" that pulls any person from the main table that is "Overdue" and their site is the same as the [_thisrow].[name]
When I include <<[overdue list]>> in an email the results are:
Bennett Smith , Castellano Smith , Cook Smith , Gonzales Smith , Levesque Smith , Lomio Smith
I would like this:
Bennett Smith
Castellano Smith
Cook Smith
Gonzales Smith
Levesque Smith
Lomio Smith
Like I said I think its done with a <<start:>> expression but im not sure the format. I have tried multiple variations but nothing is working, Any ideas?
Solved! Go to Solution.
Try..
<<Start:SELECT(Overdue[KeyColumn],[SiteName]=[_THISROW].[Name])>>
<<[ColumnName]>>
<<End>>
Try..
<<Start:SELECT(Overdue[KeyColumn],[SiteName]=[_THISROW].[Name])>>
<<[ColumnName]>>
<<End>>
so I tried
<<Start:SELECT(main[employee id], [Site Name]=[_THISROW].[Name])>>
<<[Overdue List]>>
<<End>>
and the results were
Bennett Smith , Castellano Smith , Cook Smith , Gonzales Smith , Levesque Smith , Lomio Smith
Bennett Smith , Castellano Smith , Cook Smith , Gonzales Smith , Levesque Smith , Lomio Smith
Bennett Smith , Castellano Smith , Cook Smith , Gonzales Smith , Levesque Smith , Lomio Smith
Bennett Smith , Castellano Smith , Cook Smith , Gonzales Smith , Levesque Smith , Lomio Smith
Bennett Smith , Castellano Smith , Cook Smith , Gonzales Smith , Levesque Smith , Lomio Smith
Bennett Smith , Castellano Smith , Cook Smith , Gonzales Smith , Levesque Smith , Lomio Smith
Bennett Smith , Castellano Smith , Cook Smith , Gonzales Smith , Levesque Smith , Lomio Smith
Bennett Smith , Castellano Smith , Cook Smith , Gonzales Smith , Levesque Smith , Lomio Smith
So I have a column now but a column of all names repeated.
Do I need to use a template and put it in a table?
No, it's not needed. You should get rid of the virtual column (as it's a list of names) and then read users inside of the Start: & End.
I tried a template and used a table and I got the same results
Got it! Thank you!
Try this:
Bennett Smith&"
"&Castellano Smith"
"&Cook Smith"
"&Gonzales Smith"
"&Levesque Smith"
"&Lomio Smith
Remember to hit enter between " and "
User | Count |
---|---|
44 | |
31 | |
29 | |
14 | |
14 |