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.

Format the text in a rollup field (Concatenate?)

Topic Labels: Formulas
Solved
Jump to Solution
1855 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Anxious
7 - App Architect
7 - App Architect

Is there a way to format the items in the rollup field to look like this (including brackets on either side):

[“Choice1”,“Choice2”,“Choice3”,“Choice4”,“Choice5”]

I have this formula but it does not work in a rollup field:

'["' & 
SUBSTITUTE(
  Choices,
  ', ',
  '","'
) & 
'"]'

Then I found this sample code:

IF(
  ARRAYJOIN(values),
  "- " & ARRAYJOIN(values, "\n- ")
)

But I can’t figure out how to combine them without an error.

IF(
  ARRAYUNIQUE(values),
  '["' & ARRAYUNIQUE(values,   ', ',
  '",") & 
'"]'
)

All these “,”"’’ are making me go cross eyed. Please help me! :rofl:

Airtable Account: Free Plan
Records: 1,200/1,200 1000/1000 (I might have to find a different solution soon)
Automation Runs: ??/100
Extensions: 1/1 (TinyPNG Compression Script, looking for free alternatives)
1 Solution

Accepted Solutions

Your last formula is close. Try:

IF(
  values, 
  '["' & ARRAYJOIN(ARRAYUNIQUE(values), '", "') & '"]'
)

See Solution in Thread

3 Replies 3
Anxious
7 - App Architect
7 - App Architect

Still trying different configurations, but I still can’t get it to work. What am I doing wrong? Is this even possible?

Airtable Account: Free Plan
Records: 1,200/1,200 1000/1000 (I might have to find a different solution soon)
Automation Runs: ??/100
Extensions: 1/1 (TinyPNG Compression Script, looking for free alternatives)

Your last formula is close. Try:

IF(
  values, 
  '["' & ARRAYJOIN(ARRAYUNIQUE(values), '", "') & '"]'
)
Anxious
7 - App Architect
7 - App Architect

Thank you! I don’t know why I didn’t use both arrayjoin and arrayunique.

Airtable Account: Free Plan
Records: 1,200/1,200 1000/1000 (I might have to find a different solution soon)
Automation Runs: ??/100
Extensions: 1/1 (TinyPNG Compression Script, looking for free alternatives)