Convert an Array (Multiple Select) into a String with formatting

[jdoepker]

Hi there,

I'm trying to utilize Airtable to manage Shopify Metafields (among other things), but am striking out with doing this in what I believe to be the most logical way.

I've configured a field (column) as "multiple select" with preconfigured options (the array). This ensures we're dealing with legitimate values.

Syncing to Shopify, through the use of AirPower, requires the metafields to be in the format:

["MF1","MF2","MF3"] 

I've used ARRAYJOIN to convert the array to a string in a separate field, but am stumped at actually formatting the square brackets and quotes.

Suggestions?

TIA,

Jeff

[TheTimeSavingCo · Accepted solution]

Try something like:

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

 

[jdoepker]

Thank you very much Adam!

This worked perfectly.