Help

Formatting multiple choice dropdown menu with a formula

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

So I have a multi-select field that has about 50 or so options. I want to take those options and surround them with quotation marks, separated by a comma. I tried using the SUBSTITUTE, but I couldn’t get it to work the way I wanted without duplicating the field a few times. I did something similar to below, but now I have three extra columns in my table…heh.

SUBSTITUTE({Calculation},", ",",\"")

I am wanting to take this:
image

and turn it into this:

[“Pet Doll”,“Chubby”,“Child”,“Wings”,“Horns”,“Round Face”,“Pointed Ears”]

Complete with brackets on each end. How would I go about doing this? I don’t know if scripting will work because I’m trying to import my airtable into another service and in order for those choices to be recognized as tags, they have to be formatted as you see above. So the field has to have that data in it.

I have hundreds and hundreds of rows, so doing it by hand is not an option.

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
TheTimeSavingCo
18 - Pluto
18 - Pluto

Hey man, try this out:

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

Screenshot 2022-06-09 at 1.58.10 PM

See Solution in Thread

2 Replies 2
TheTimeSavingCo
18 - Pluto
18 - Pluto

Hey man, try this out:

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

Screenshot 2022-06-09 at 1.58.10 PM

Anxious
7 - App Architect
7 - App Architect

Wow! You are amazing. Thank you!

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)