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. 

[Théau]

Hey @jdoepker, you can also check SyncBase (an Airtable Shopify integration) I've created.

In opposition to Airpower we're doing this job on our side, and it syncs instantly (few seconds).

Happy to give more info if needed! 

Théau