What are you trying to achieve?
I’m trying to obtain a text aggregating dates and names.
I’ve go to the point where I have an array aggregator outputting correctly my data :
OUTPUT
[
{
“IMTKEY”: “Bacchus”,
“array”: [
{
“Date”: “2025-06-02”,
“Educ”: “Vanessa”
},
{
“Date”: “2025-05-30”,
“Educ”: “Charly”
},
{
“Date”: “2025-06-25”,
“Educ”: null
}
]
}
]
Now I’m trying to get an aggregated Text as follow:
- 02/06/2025 — Vanessa
- 05/06/2025 — Vanessa
- 25/06/2025 — (vide si Educ absent)
This is to then export into a google document (billing) where I want them displayed as a table.
Steps taken so far
My PROBLEM is that when trying to aggregate these into a text aggregator I’m setting up as
- {{formatDate(Date; “DD/MM/YYYY”)}} — {{Educ}}
The variables Date and Educ are not recognised (displayed as Black)
When I try to set them as
- {{formatDate(24.Date; “DD/MM/YYYY”)}} — {{24.Educ}}
they appear in green, but light green
When I try setting as
{{formatDate(24.array[1].Date; “DD/MM/YYYY”)}} — {{24.array[1].Educ}}
to test if the system can access the array correctly, it work but (as expected) I only get the first row.
02/06/2025 — Vanessa
Can someone help me?
This seemed like pretty simple steps but can’t seem to make it work.
Thanks in advance!