I have a Jotform survey with questions that allow for multiple choices. I created a Zap that goes to a Google Doc template and when I choose multiple options for a question the selections come in with semicolons (;) but I am hoping that they come in with commas instead. Is there a way to do this?
Best answer
Jotform to Google Docs Template (Changing from semicolon to comma)
- Beginner
Best answer by Danvers
Hi
Yes, there’s a way to do this :)
You’ll need to add a Formatter step into your Zap. Choose the Formatter app and the option to work with text. For the transform, choose the Replace option. That will allow you to replace all of the semi-colons with commas.
The last thing to remember is that for the Google Docs step, make sure that you choose the output from the Formatter step, and not the original input from the trigger.
I hope that’s all clear, let me know if you have any questions!
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+12- Zapier Staff
- Answer
Hi
Yes, there’s a way to do this :)
You’ll need to add a Formatter step into your Zap. Choose the Formatter app and the option to work with text. For the transform, choose the Replace option. That will allow you to replace all of the semi-colons with commas.
The last thing to remember is that for the Google Docs step, make sure that you choose the output from the Formatter step, and not the original input from the trigger.
I hope that’s all clear, let me know if you have any questions!
- Beginner
Danvers! Thank you so much I am going to try it and if I have any questions I’ll come back and post. You don’t know how much I appreciate this but I hope my sincerest thanks will do :-)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.