What is your goal?
I am a beginner
I have a problem to get a several field from jotform to google sheets.
From what I read, it is becasuie the answers from jotform are in an array and I need to comptue a formula to get te data.
What is the problem & what have you tried?
I tired several soltuion included a get(array, Number) but can’t get the data
See screenshot, i have the two uirst data in Gsheet ( data are issued by jotform) but the answers to my from (here consultant name) I vcan’t get it in G sheet
see pdf attached
Error messages or input/output bundles
No errors, but IO don’t have the data in Gsheet
Thansk for your hel^p
Screenshots (scenario flow, module settings, errors)
Jotform.pdf (51.7 KB)
1 Like
Hi @Benoit_Stefani ,
If you are sure that only one name is coming from JotForm inside the ConsultantNom array, then you do not need to use any array functions or get() formula.
You can directly map the ConsultantNom field from the JotForm module to the Values field in the Google Sheets Add a Row module.
As shown in the attached screenshot, I have taken sample data exactly in the same structure as JotForm sends it and used it in the Parse JSON module. Since the parsed output already contains a single value for ConsultantNom, it can be mapped directly to Google Sheets without any additional computation.
Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation
Many thanks for your reply. Appreciate it.
Nevertheless, I thinlk there is a slight difference as in your exemple the array “consutlant name” is highlighted in purple and then Name and answers are also in purple and I think it means you can select it directly whereas in my example, consultant name is highlighted but not the answers, i Only have otpion 1 and 2 (not highlighted) I don’t think I cans select this “not highlighted” fields.
Does that make sense ?
Many thanks again
1 Like
Hi @Benoit_Stefani ,
Could you please share the JSON output bundle from the Jotform module ?
Having the exact JSON response will help me troubleshoot the issue more quickly and accurately , as it represents the real data structure we need to work with. Once I have that, it will be much easier to identify the root cause and provide the correct solution.
Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation
1 Like
Jason jotform output bundle.txt (3.7 KB)
Many thansk for your help.
Attached is tje jason output file from jotform module as requested
Thanks
1 Like
Hi @Benoit_Stefani ,
Thank you for sharing the JSON output bundle from JotForm . This helped me understand the data structure and resolve the issue much more easily.
Please use one of the following formulas if you are sure that only one name is coming from JotForm inside the ConsultantNom array :
{{get(68.answers.consultantNom; 2)}}{{68.answers.consultantNom[2]}}
Based on your screenshot, it seems that the correct array element was not selected . Could you please recheck this and make sure the appropriate array value is chosen, as shown in the screenshot!
Hope this should address the issue correctly.
Please feel free to contact us if you need any further assistance.
Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation
1 Like
Hey Benoit,
the JSON you shared doesn’t match the screenshot you provided. Inside the JSON the value is inside an array and you can easily map it. In the screenshot it is not. Can you share a screenshot of what the Jotform output looks like?
1 Like
Hello,
thank you again. I really appreciat your help.
But there is something I don’t here @Msquare_Automation
In your screenshot , there is a subdivison below “nom consutlant” / littel arrow on the side
And I don’t have that.
Screenshot.docx (168.1 KB)
The json is the one I provided and you can see the screen shot attached where I don’t see the same data as the one you have on the screenshot (no arrow, no subdivision belon nom consultant)
@Stoyan_Vatov I thionk I see what you mean, but here is he data I see with the Jason I provided earlier.
Maybe I should try all over again with a new jotform
Thanks again for your help
1 Like
Hi @Benoit_Stefani ,
It would be helpful if you could share a Loom screen recording explaining the issue.
Please walk us through the full scenario flow and point out where the issue occurs.
Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation
