Convert "Array" to "text with commas"

How To
,
1

Hi, I have to fill a “Google Docs” Template from a “CognitoForms” form.

In Google Docs, I have to replace the {{options}} variable with a text:
3
The problem is that the variable come from CognitoForms in the form of an array:
1

So I have an error in Create Google Docs from Template module:
2

How can I transform the array to a simple text separated with commas?
In my example, it should be: “Faux ventre, Paire de lunettes, Cloche, Sac à jouets”

Here is the JSON format:

"VotreDemande": {
    "JourRetrait": "2023-12-01",
    "Email": "xyz@mail.com",
    "JourRetour": "2023-12-04",
    "Taille": "54/56",
    "Options": [
      "Faux ventre",
      "Paire de lunettes",
      "Cloche",
      "Sac à jouets"
    ],
    "Options_Amount": 9,
    "Options_QuantitySelected": 1,
    "Options_Price": 9,
    "Total": "89",
    "Prix": 89,
    "Prix_IncrementBy": 1

Thanks for your help!

2

Hi @Alex2 ,

I think that the join function could be a good solution.

BR,

PBI

3 Likes
3

@Philippe_Billet Thanks a lot! So simple but so powerful :slightly_smiling_face:

3 Likes