Hey guys, I need some help please
I’m trying to send information from a form via email.
There are 7 answers. Which arrive via webhook. As per the first image.
However, when I select the variables corresponding to each answer in the second stage of the flow, they do not appear the way I would like in response 1, 2, 3, 4, 5, 6, 7
How do I pull the 7 answers into separate variables?
I’m new to programming, but I understand a little logic.
If anyone can help me I will be grateful.
Hi @Vitor_Rocha
You iterator module then use text aggregator module
Hey @Vitor_Rocha
welcome to the make community
When mapping the direct array, it only provides us with the first value. To solve this, we can utilize an iterator here
Right. I partially solved the problem. I managed to separate the answers.
But when using the text aggregator, the form answers stayed together. I would like to separate the answers into different variables to send by email or to place in a spreadsheet, for example.
Can you help me do this. I probably have to use another module for this. I tried using “Set Variable Module”, but it didn’t solve the problem.
Thanks for the help so far
The t param is always nested in c nested in answers?
Answer array is always in the same length?
The t param is always returned as single item of an array?
There are 7 answers. The first 5 are parameter “t” nested in the array “c”. Because they are multiple choice questions.
The other 2 answers are outside array “c”.
With the iterator I was able to separate the 5 initial answers. Now I need to place each of them in separate variables so that I can place them in different columns in the spreadsheet.
“answers”: [
{
“q”: “649c8afc9c359d1b4d392b56”,
“c”: [
{
“t”: “Casa em Condomínio”,
“v”: “649c8b069c359d1b4d392b5e”
}
]
},
{
“q”: “649c8b919c359d1b4d392b92”,
“c”: [
{
“t”: “2 Dormitórios”,
“v”: “649c8b939c359d1b4d392ba9”
}
]
},
{
“q”: “65e0c765da02063bd21b4ec7”,
“c”: [
{
“t”: “Mont’Serrat”,
“v”: “649c8b939c359d1b4d392baa”
}
]
},
{
“q”: “65e0c7d6da02063bd21b4efa”,
“c”: [
{
“t”: “R$900 a R$1 Milhão”,
“v”: “649c8b939c359d1b4d392baa”
}
]
},
{
“q”: “65e0c845da02063bd21b4fcd”,
“c”: [
{
“t”: “Sim”,
“v”: “65e0c6fdda02063bd21b4c9e”
}
]
},
{
“q”: “63f3950e9d055e2d238cdc43”,
“t”: “Vitor”
},
{
“q”: “63f395239d055e2d238cdc4a”,
“p”: {
“p”: “51999080886”
}
}
],
Got it thanks for the detailed explanation.
What I suggest to do in this case
Since the form is static and the question id are static you can just add a set multiple param
Directly after the hook
Then in the multiple param module add new param per question
Then with map and get functions you’ll be able to set the relevant data to each param
For example for the first param write somthing like this:
join(map(map(answers;c;q;{{questionid}});t);,)
I am not on pc right know so once i get back home i can write it all for you
I thank you for all the attention you are giving me.
I think I understand. After the webhook I place the “set multiple variables” module
And in the “Variable value” field join(map(map(answers;c;q;{{questionid}});t);,)
Manually replacing the “question id” for each 1 of the answers and also the path to the last 2 answers that are different…
If I’m wrong, sorry for my stupidity, I’m like a baby with programming and automation.
I didn’t write it in way you can just copy
I thought you understand how map function is working.
Its fine.
{{join({{map({{map({{4.’answer.answers’}};c;q;649c8afc9c359d1b4d392b56)}};t)}};,)}}
Let me know if you figured it out:)
If the answers will return in any other order for example if the answers will return descending instead of ascending you will insert wrong data into wrong places 
Use this in the meantime. I will fix it for you oncw i get home 
It will be? I think the order of answers will always be fixed. Unless I change the application of the form…
From my experience unless you build the form platform it cant be granted 
Hi Dorian, I have that problem you warned me about 20 days ago…
I have a form that sometimes has 7 and other times has 8 responses so by automating it the way I did I put the wrong data into wrong places…
How do I set the parameters correctly to always pull the correct data? Can you help me please?
