I have a Google Form. One of the questions has a multiple-choice answer with checkboxes. I want this data to appear in my Airtable base as a multiple-selection field. However, my ‘get a response Google Forms’ module returns the answers in the form of multiple text responses. However, only the first one appears in my Airtable table using my upsert function. How can I solve this problem?
What you want is to map all the values at the same time.
Links
Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —
If I click on map, like it appears on your picture, result is the same. When I click in the value field and search something like a multiple value I can’t find anything :
Now I have my 2 roles, with the text aggregator. My new problem is how to insert it in Airtable. Do you know the correct separator to use ? To separates my 2 text strings ?
Congratulations on solving this one with @samliew’s help. You truly did a great job!
Also thank you very much for sharing your solution here. We appreciate you keeping us in mind and maintaining the community healthy and organized for others.