Array to String delimited by newLine

[we_doc]

hi im new to Make
maybe im not using the right scenario tools but every thing that i’ve tried does not give me the array items as a string delimited by new line
the scenario :
get data from googleSheet (apps script)
convert it into json
one of the json field is an array which i want to send as a long string delimited by new line

INPUT

---

[
{
“array”: [
{
“calendarName”: “ROOM 3”,
“freeTimeSlots”: [
“07:00 - 07:30”,
“07:00 - 08:00”,
“08:00 - 08:30”,
“08:00 - 09:00”,
“09:00 - 09:30”,
“09:00 - 10:00”,
“10:00 - 10:30”,
“10:00 - 11:00”,
“11:00 - 11:30”,
“11:00 - 12:00”,
“12:00 - 12:30”,
“12:00 - 13:00”,
“13:00 - 13:30”,
“13:00 - 14:00”,
“14:00 - 14:30”,
“14:00 - 15:00”,
“15:00 - 15:30”,
“15:00 - 16:00”,
“16:00 - 16:30”,
“16:00 - 17:00”,
“17:00 - 17:30”,
“17:00 - 18:00”,
“19:00 - 19:30”,
“19:00 - 20:00”,
“20:00 - 20:30”,
“20:00 - 21:00”,
“21:00 - 21:30”,
“21:00 - 22:00”,
“22:00 - 22:30”,
“22:00 - 23:00”,
“23:00 - 23:30”
]
},
{
“calendarName”: “ROOM 2”,
“freeTimeSlots”: [
“07:00 - 07:30”,
“07:00 - 08:00”,
“08:00 - 08:30”,
“12:00 - 12:30”,
“12:00 - 13:00”,
“13:00 - 13:30”,
“13:00 - 14:00”,
“14:00 - 14:30”,
“14:00 - 15:00”,
“15:00 - 15:30”,
“15:00 - 16:00”,
“16:00 - 16:30”,
“16:00 - 17:00”,
“17:00 - 17:30”,
“17:00 - 18:00”,
“18:00 - 18:30”,
“20:30 - 21:00”,
“20:30 - 21:30”,
“21:30 - 22:00”,
“21:30 - 22:30”,
“22:30 - 23:00”,
“22:30 - 23:30”
]
}
]
}
]

OUTPUT

---

[
{
“text”: “07:00 - 07:30, 07:00 - 08:00, 08:00 - 08:30, 08:00 - 09:00, 09:00 - 09:30, 09:00 - 10:00, 10:00 - 10:30, 10:00 - 11:00, 11:00 - 11:30, 11:00 - 12:00, 12:00 - 12:30, 12:00 - 13:00, 13:00 - 13:30, 13:00 - 14:00, 14:00 - 14:30, 14:00 - 15:00, 15:00 - 15:30, 15:00 - 16:00, 16:00 - 16:30, 16:00 - 17:00, 17:00 - 17:30, 17:00 - 18:00, 19:00 - 19:30, 19:00 - 20:00, 20:00 - 20:30, 20:00 - 21:00, 21:00 - 21:30, 21:00 - 22:00, 22:00 - 22:30, 22:00 - 23:00, 23:00 - 23:30\n07:00 - 07:30, 07:00 - 08:00, 08:00 - 08:30, 12:00 - 12:30, 12:00 - 13:00, 13:00 - 13:30, 13:00 - 14:00, 14:00 - 14:30, 14:00 - 15:00, 15:00 - 15:30, 15:00 - 16:00, 16:00 - 16:30, 16:00 - 17:00, 17:00 - 17:30, 17:00 - 18:00, 18:00 - 18:30, 20:30 - 21:00, 20:30 - 21:30, 21:30 - 22:00, 21:30 - 22:30, 22:30 - 23:00, 22:30 - 23:30”
}
]

[samliew]

Welcome to the Make community!

You can use the built-in function join

e.g.:

{{ join(1.array; newline) }}

For more information, see the function documentation in the Help Center.

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

[samliew]

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

Getting Started

• Help Centre | Tutorials – Make “Manual”
• Make Academy – Basics 101: Learn Make and get certified

Help Centre Basics

• Mapping – What is mapping? What can I map?
• Mapping with arrays – How to map items in an array
• Aggregate an array for mapping complex fields
• Date Format: tokens for parseDate | tokens for formatDate
• HTTP modules – Make a request, Get (download) a file
• Webhooks – Error Handling, Responding to webhooks

Articles & Videos

• Router Magic Formula - YouTube
• Error Handlers in Make - YouTube playlist
• Getting started with OpenAI - How to setup and use OpenAI (ChatGPT) in Make
• How to use Regex in Make - How to use pattern matching to extract the text you want
• Webhooks – Make Academy – tutorial on how to use Webhooks