Solving Google Form Responses Mapping Issue on Make.com

Have you ever faced a problem where your Google Form responses are not mapping all the values? Specifically, when you have a checkbox response in your form and you want to map all the selected options into a Google Doc, but it only shows the first value. This is a common issue faced by many Make.com users, and in this blog post, we will provide a step-by-step solution to this problem.

The Problem

Let's say you have a Google Form with a question that has a checkbox response. You have selected multiple options for this question. Normally, the response should be registered as a single string with all the selected options. For example, if you have selected 'Facebook', 'Google', and 'Creative', the response should be 'Facebook, Google, Creative'.

However, when you try to map these responses into a Google Doc, it only shows the first value. In this case, it only shows 'Facebook'.

The Solution

The solution to this problem is to use the map function to grab all the values from the Google Form Submission Response and then use the join function to get a comma-separated value. This value can then be sent to Google Docs.

Here is the code snippet that you can use:

{{join(map(2.answers.53d47889.textAnswers.answers; "value"); ",")}}

In this code, {{2.answers.53d47889.textAnswers.answers}} is the answers you have in the mapping menu.

Troubleshooting Tips

If you are still facing issues, make sure that you have correctly mapped the answers in the mapping menu. Also, check if you have correctly used the join and map functions.

Conclusion

In conclusion, the issue of Google Form responses not mapping all the values can be solved by using the map and join functions. This will allow you to get a comma-separated value of all the selected options, which can then be sent to Google Docs. We hope this solution helps you in your automation tasks on Make.com.

You do have further questions?

Ask your question via E-Mail: Richard@make-app.de
Book a paid Support & Consulting Session
New Make.com user? Sign up through this Affiliate Link to receive 10.000 operations for FREE.