Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

ARRAYJOIN(ARRAYCOMPACT())

Topic Labels: Formulas
Solved
Jump to Solution
1129 1
cancel
Showing results for 
Search instead for 
Did you mean: 
n0xp
6 - Interface Innovator
6 - Interface Innovator

Hi everyone,

 

I'm trying to get this formular to work, and although it parses there's no output.

 

 

 

ARRAYJOIN(ARRAYCOMPACT(Field1,Field2,Field3,Field4), ", ")

 

 


The fields are a mix of and link-to-another-record fields lookups (of link-to-another-record fields) where the outputs all are fine. The reason why I'm using an ARRAYCOMPACT as well is because half of the fields are usually empty.

Thank you very much ❤️


1 Solution

Accepted Solutions
n0xp
6 - Interface Innovator
6 - Interface Innovator

Solved by myself.

For anyone ever in the same boat as I was. ARRAYFLATTEN() by itself combined all not empty fields with commas in between. ❤️

See Solution in Thread

1 Reply 1
n0xp
6 - Interface Innovator
6 - Interface Innovator

Solved by myself.

For anyone ever in the same boat as I was. ARRAYFLATTEN() by itself combined all not empty fields with commas in between. ❤️