I have a virtual text column called [Description], which is the concatenated value of three other columns, but I can't get it to display the way I'd like.
The desired output is:
"[column A]
[column B]
[column C]"
The result I keep getting is: "[column A] [column B] [column C]". Is it possible to get multi-line text output for a single column?
Solved! Go to Solution.
Yes, you can do this in a LongText type column. You will need to build the text with newlines inserted, like this:
[Column A] & "
" & [Column B] & "
" & [Column C]
The quotes are surrounding the newline, with the second " on the next line.
Yes, you can do this in a LongText type column. You will need to build the text with newlines inserted, like this:
[Column A] & "
" & [Column B] & "
" & [Column C]
The quotes are surrounding the newline, with the second " on the next line.
exactly what I needed. Thank you!
User | Count |
---|---|
14 | |
11 | |
9 | |
7 | |
4 |