Airtable & word template loop or section

[JanGoMak]

Hi community,

I have been battling to fill in a section of my Word template for some time now.

I am trying to create a weekly time sheet and want to send it out on Fridays.
It should show the week’s tasks broken down by day.

The template contains various fields like name, address, etc. that work fine, but the loop section for the day does not want to work correctly.

This is how the loop section is set upin the word template:

The scenario looks like this:

The output of the array aggregator is the following:

[
    {
        "array": [
            {
                "Day": "Wednesday",
                "Notes": "General General tasks for testing purposes ",
                "Created": "2025-03-05",
                "Start Time": "2025-03-05T02:00:00.000Z",
                "createdTime": "2025-03-05T14:47:16.000Z",
                "Billable Hours": 6
            },
            {
                "Day": "Thursday",
                "Notes": "Neque porro quisquam est qui dolorem ipsum quia dolor sit amet, consectetur, adipisci velit...",
                "Created": "2025-03-06",
                "Start Time": "2025-03-04T02:29:00.000Z",
                "createdTime": "2025-03-06T02:28:55.000Z",
                "Billable Hours": 4
            }
        ],
        "__IMTAGGLENGTH__": 2
    }
]

The setup of the word document looks like this:

The word template input looks like this:

    {
        "data": "IMTBuffer(69480, binary, 23e6e71bd76d186800fdeee3038fdc834ff47c5f): 504b030414000600080000002100329b7152a6010000230a0000130008025b436f6e74656e745f54797065735d2e786d6c20a2040228a0000200000000000000000000000000000000000000000000000000000000000000000000000000000000000000",
        "values": [
            {
                "key": "overview",
                "value": [
                    {
                        "entry": [
                            {
                                "key": "notes",
                                "value": "General General tasks for testing purposes "
                            },
                            {
                                "key": "hours",
                                "value": "6"
                            },
                            {
                                "key": "day",
                                "value": "Wednesday"
                            },
                            {
                                "key": "created",
                                "value": "2025-03-05"
                            }
                        ]
                    }
                ],
                "valueType": "loop-section"
            }
        ],
        "fileName": "06.03.2025",
        "dataSource": "form"
    }

I already searched the internet and the forum and got mixed messages about using aggregators. I also saw the Make.com word tutorial

I tried numerous ways and had either two documents created or one with only one section, rather than the desired 5.

Any help would be highly appreciated.

Thanks in advance,

Jan

[Stoyan_Vatov]

Hey Jan,

your mapping logic is wrong - first you are aggregating in an array, then you are trying to map individual items and not the array itself. See if the array is following the same structure as the module expects and toggle the Map button next to Value to map the entire array.

[JanGoMak]

Hi Stoyan,

Thank you very much for your reply.
I am a newbie trying to figure this out, so I don’t understand what you said.
Maybe aggregator, etc, are not the best to start the learning.

I tried a few different things but still don’t get the desired result.
Hopefully it is just a quick fix, and for full transparency and efficiency, I uploaded the blueprint here.

blueprint-2.json (71.9 KB)

Thanks again and I hope this can be resolved,

Warm regards,

Jan