How do i get these form responses that are 4 levels nested in to map to Airtable?

[Chasity_Williams1]

I’ve spent 6 hrs on this and still can’t figure it out.

I’m collecting form submissions from a platform called One Church and they have the questions nested 4 levels down and each question is a collection of info. I only need the question id, label, and response to insert the form responses into Airtable.

How do I:

1. pull all the responses
2. change “label” to the actual question
3. change “response” to the actual answer
4. make them available to map to Airtable?

UoF Auction Submissions- One Church to Airtable.blueprint.json (50.3 KB)

[Prem_Patel]

Hey @Chasity_Williams1 Welcome to the community!

You can iterate the data of your main responses using iterator

and then you can use Map function over responses array to get answers for each question respectively in your airtable inputs mapping. I am using id of questions as question label can contain comma which can affect the mapping. so it’s better to use strings which doesn’t contain the comma. You can replicate the formula by just updating the question id.

I hope this helps!

Best,
@Prem_Patel

[Chasity_Williams1]

Thanks! I got this far….

1. Tweaked what you did to have one set variable

   

2. This is the output — all in individual operations but the q and a are matched correctly

   

3. But then when connecting to Airtable, only two Q’s are available to map

   

4. Then the same submission is added to Airtable for the number of questions asked

   

   How do I get all the questions to show to map and not have it duplicate the same submission?

[Chasity_Williams1]

I found the solution using Javascript that Chatgpt made for me:

[Prem_Patel]

Set Variable module was used just for example of map function. you can set those formula’s directly in airtable