Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Commas separating items in array lost

Topic Labels: Formulas
Solved
Jump to Solution
5228 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Michael_Benson
6 - Interface Innovator
6 - Interface Innovator

Hi there,

I have a rollup field - Field A - which displays items in an array using a comma separator. I retrieve the items using ARRAYUNIQUE(values).

When I try and call this field in another field - Field B, this formula keeps the comma separator:

{Field A}
Produces: 1, 2, 3

When I try and add text to the formula, the commas are lost and the values aren’t separated but bunch into one long block of text:

{Field A) & " Text"
Produces: 123 Text

Would anyone be able to help? How can I add the commas/separators back in between these values?

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

Try this:

ARRAYJOIN({Field A},", ") & " Text"

There are probably other ways of handling this too, but that should work.

See Solution in Thread

4 Replies 4
ScottWorld
18 - Pluto
18 - Pluto

Try this:

ARRAYJOIN({Field A},", ") & " Text"

There are probably other ways of handling this too, but that should work.

kuovonne
18 - Pluto
18 - Pluto

Or convert the formula in the rollup field to

ARRAYJOIN(ARRAYUNIQUE(values), ", ")

In either case, you need to use ARRAYJOIN.

Thanks both!

I’ve opted for Scott’s approach as I still need to be able to count items in the array.

I didn’t realise we could use ARRAYJOIN outside of a Rollup field. The documentation seems a little unclear: https://support.airtable.com/hc/en-us/articles/360052869513-Array-functions

Cheers

Yeah, they have errors in their documentation for many different functions. Glad you got it working!