Help

ARRAYJOIN(ARRAYCOMPACT())

Topic Labels: Formulas
Solved
Jump to Solution
524 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. ❤️