Skip to main content
Solved

ARRAYJOIN(ARRAYCOMPACT())

  • February 9, 2023
  • 1 reply
  • 63 views
N
Forum|alt.badge.img+4
  • n0xp
  • Inspiring
  • 8 replies

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 ❤️


Best answer by n0xp

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. ❤️

1 reply

N
Forum|alt.badge.img+4
  • n0xp
  • Author
  • Inspiring
  • 8 replies
  • Answer
  • February 9, 2023

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. ❤️


Terms & ConditionsAccessibility statement