Question

Need multiple choice answers input in single google column

  • 23 August 2021
  • 3 replies
  • 263 views

I have a current typeform with multiple choice questions. When zapping to google sheets, these populate as one per row. I need them to populate to the same row, separated as commas.


The typeform question reads:

Which tags would you like to add to your post?

Marketing

Design

Operations

 

Each of these get added as their own separate answer in google, but I need them to go into one column, separated by commas.

 

Thank you!

 

 

 


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Userlevel 7
Badge +14

Hi @amaclean 

I believe the Typeform Zap app integration sends multiple choice questions values as separate fields that can be mapped in the Zap OR as 1 field that is comma separated that can be mapped in a Zap.

Give that a try and let us know if you were able to figure it out.

Help article: https://zapier.com/help/doc/common-problems-typeform#im-missing-answers-to-multiple-choice-questions

Hi Troy-- thanks for the help! I can add all tags (see screenshot) but cannot figure out how to get the answers comma separated.

 

Userlevel 7
Badge +14

Hi @amaclean 

You can manually add commas between the mapped data points.

Meaning a Zap action field can have a combo of dynamic and static values.

NOTE: You will get multiple consecutive commas (e.g. ,,,) if there is “no data” for a given mapped data point.