Merge multiple variables into one

How To
, ,
1

In a nutshell, I’m trying to merge multiple variables into one. It seems pretty simple; however, I’m struggling with the combination part. In my scenario, a Webhook from Forminator Forms sends data in a single bundle. The unique fields are easy to manage, but the challenge arises with the Repeatable Fields. These fields come in three different types (date, currency, and text area), with at least 40 different entries (e.g., Date_3_1 … Date_3_40; Currency_1_1 … Currency_1_40; Text-area_3_1 … Text-area_3_40).

My process takes Forminator entries from the website, sends them to a Google Docs template, which is then downloaded and stored in a Google Drive repository. The issue I’m facing is how to handle the repeatable field entries so that the Google template captures them correctly.

I tried addressing this by using Google Sheets with an iterator and aggregator to process the entries, but unfortunately, it didn’t work. :frowning:

(I’m not a native english speaker, sorry for the bad english)

image
image1419×815 83.2 KB

2

Welcome to the Make community!

You can do that by setting the Webhook “JSON Pass-through” to YES (it is “No” by default), when creating or editing a webhook.

1004×445 70.7 KB

Then, paste the output bundle here.

Please provide the output bundles of the trigger modules by running the scenario (or get from the scenario History tab), then click the white speech bubble on the top-right of each module and select “Download input/output bundles”.

A. Upload as Text File

Save each bundle contents in your text editor as a bundle.txt file, and upload it here into this discussion thread.

B. Insert as Formatted Code Block

If you are unable to upload files on this forum, alternatively you can paste the formatted bundles.
These are the two ways to format text so that it won’t be modified by the forum:

  • Method 1: Type code block manually

    Add three backticks ``` before and after the content/bundle, like this:

    ```
    content goes here
    ```

  • Method 2. Highlight and click the format button in the editor

Providing the input/output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.

This will allow others to better assist you. Thanks!

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.

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

3

Hello Sam,

This is the output of my Webhook (which triggers the scenario):

[
    {
        "value": "{\"name_1\":\"Joenilton Da Silva\",\"date_1\":\"23\\/10\\/2024\",\"date_2\":\"24\\/10\\/2024\",\"textarea_1\":\"Cria\\u00e7\\u00e3o de portif\\u00f3lio\",\"textarea_2\":\"Bauru\\/SP - Americana\\/SP\",\"date_3\":\"23\\/10\\/2024\",\"currency_1\":\"340,00\",\"textarea_3\":\"Ped\\u00e1gio em Franco da Rocha\",\"currency_2\":\"56,00\",\"radio_1\":\"two\",\"date_4\":\"22\\/10\\/2024\",\"referer_url\":\"\",\"_wp_http_referer\":\"\\/reembolso-viagem\\/\",\"page_id\":\"12458\",\"form_type\":\"default\",\"current_url\":\"https:\\/\\/institutosoma.org.br\\/reembolso-viagem\\/\",\"render_id\":\"0\",\"input_15\":\"\",\"date_3_2\":\"24\\/10\\/2024\",\"currency_1_2\":\"23,00\",\"textarea_3_2\":\"Ped\\u00e1gio em Francisco Morato\",\"calculation_1\":\"R$ 363,00\",\"calculation_2\":\"R$ 307,00\",\"_forminator_user_ip\":null,\"form_title\":\"Reembolso Viagem\",\"entry_time\":\"2024-10-22 09:12:41\"}"
    }
]

Some entries contain Portuguese characters (like “ó” in “Portfólio”), which makes parts of the JSON appear strange.