Creating a text string based on an array of collections

[Pascal]

I have a scenario that starts when a video is created with Videoask. The video is a pre-interview video that a candidate submits prior to being selected for a formal interview. The system allows the candidate to answer several questions, and for most of the questions, they record a video. The module sends various information, including the transcript for each answer provided.

The answers are located in an array of collections:

If there is no transcript, then the scenario should disregard this specific collection. The scenario needs the transcript from each collection requiring a video recording, therefore creating a transcript from the answer.

I need to be able to extract the transcript from each collection, along with the question associated with the transcript. Collection 1 does not have a transcript in this example, as it is not a video question but a checkbox in the Videoask process. Therefore, this should be disregarded automatically. What I want to achieve is this result:

A generated text where I will have:

QUESTION1: HERE THE QUESTION 1 (I can type it manually)
Transcript: {{Here is the value from the field of the first question to be processed, which in this case is Collection 2.}}

I know which question corresponds to which collection, so it is not an issue for me to know that Collection X is related to this specific Question Y.

How can I concatenate this text with the transcripts, with a line break between each question and transcript?
blueprint.json (84.3 KB)

[Stoyan_Vatov]

Hey Pascal,

you can use the Iterator module to go through the array followed by a Text Aggregator module to turn the array in a long string.

[samliew]

Welcome to the Make community!

When you see ARRAY, think ITERATOR.

Then,

Aggregators

Every result (item/record) from iterator/list/search/match modules will output a bundle. This can result in multiple bundles, which then trigger multiple operations in future modules (one operation per bundle). To “combine” multiple bundles into a single variable, you’ll need to use an aggregator of some sort.

Aggregators are modules that accumulate multiple bundles into one single bundle. An example of a commonly-used aggregator module is the Array aggregator module. The next popular aggregator is the Text Aggregator which is very flexible and can apply to many use-cases like building of JSON, CSV, HTML.

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

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.

[Pascal]

Thanks, but as i need to separate each item, and add the question, i was able to do it using “Compose a string”