Help

Format the text in a rollup field (Concatenate?)

Topic Labels: Formulas
Solved
Jump to Solution
927 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)