
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 13, 2022 01:04 PM
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:
Records:
Automation Runs: ??/100
Extensions: 1/1 (TinyPNG Compression Script, looking for free alternatives)
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 14, 2022 09:19 AM
Your last formula is close. Try:
IF(
values,
'["' & ARRAYJOIN(ARRAYUNIQUE(values), '", "') & '"]'
)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 14, 2022 08:06 AM
Still trying different configurations, but I still can’t get it to work. What am I doing wrong? Is this even possible?
Records:
Automation Runs: ??/100
Extensions: 1/1 (TinyPNG Compression Script, looking for free alternatives)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 14, 2022 09:19 AM
Your last formula is close. Try:
IF(
values,
'["' & ARRAYJOIN(ARRAYUNIQUE(values), '", "') & '"]'
)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 14, 2022 10:09 AM
Thank you! I don’t know why I didn’t use both arrayjoin and arrayunique.
Records:
Automation Runs: ??/100
Extensions: 1/1 (TinyPNG Compression Script, looking for free alternatives)
