
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 31, 2022 02:04 PM
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?
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 31, 2022 02:19 PM
Try this:
ARRAYJOIN({Field A},", ") & " Text"
There are probably other ways of handling this too, but that should work.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 31, 2022 02:19 PM
Try this:
ARRAYJOIN({Field A},", ") & " Text"
There are probably other ways of handling this too, but that should work.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 31, 2022 04:04 PM
Or convert the formula in the rollup field to
ARRAYJOIN(ARRAYUNIQUE(values), ", ")
In either case, you need to use ARRAYJOIN.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 31, 2022 04:18 PM
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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 31, 2022 05:59 PM
Yeah, they have errors in their documentation for many different functions. Glad you got it working!
