Concat Formula
Is there any way to display a concat formula, but instead of displaying the items in a view like:
sample 1, sample 2, sample 3, sample 4
Can I have them in a list view, for example:
- Sample 1
- Sample 2
- Sample 3
- Sample 4
13 replies
-
Hi,
from the manual: join(array,"separator") - Returns a string result with each element separated by a separator of your choice. That can also be a line break and/or a string.
Steven
-
can you provide an excample?
-
Hi.
Try this:
---
let myArray := ['Sample 1', 'Sample 2', 'Sample 3', 'Sample 4'];join(myArray, "")---
Fabio
-
Did not work, I am working with formula concat('Customer Notes'.'Contact Date and Type');
Which is outputting: Email - 11/27/2019, Call - 11/27/2019, Email - 11/30/2019, Call - 11/30/2019, Email - 12/03/2019, Call - 12/03/2019, Email - 12/05/2019, Call - 12/05/2019, Letter - 12/05/2019, Letter - 12/05/2019, Email - 12/06/2019
I would like to specifically have:
• Email - 11/27/2019
• Call - 11/27/2019
• Email - 11/30/2019
• Call - 11/30/2019
• Email - 12/03/2019
• Call - 12/03/2019
• Email - 12/05/2019
• Call - 12/05/2019
• Letter - 12/05/2019
• Letter - 12/05/2019
• Email - 12/06/2019
I am trying to pull a list from a linked table.
-
Hi,
can you try this:
---
let q := concat
('Customer Notes'.'Contact Date and Type');join(split (q,","),"
")
---
or in one line (not sure it will work):
join(split(concat('Customer Notes'.'Contact Date and Type'),","),"
")
Steven
-
That worked! I am now trying to figure out how (with each line) to include "• "
-
Try here:
join(split(concat('Customer Notes'.'Contact Date and Type'),","),"•
")
-
For what it's worth, it looks like the formula is converting an array to a string then back to an array and then back to a string. I'm pretty sure you can just use
join()without thesplit()andconcat(). -
So in other words,
join('Customer Notes'.'Contact Date and Type',"
")
should do the trick?
S Moore, can you try this and provide feedback please?
-
Yes,
join('Customer Notes'.'Contact Date and Type',"")DOES WORK!
-
Yeah, I think the only difference between
concat()andjoin()is thatjoin()let's you use a custom separator. -
Thank you for your valued comment, Sean, we're learning every day.
-
Life would get pretty dull if we weren't.
Content aside
- 5 yrs agoLast active
- 13Replies
- 3331Views