How do we execute a multi-punch question with a comma delimiter?

Question

We have a couple of surveys with multi-punch responses and we are seeking an answer to the following question:How would we send data for multi-punch questions to Dynamics with a comma delimiter?Sample (fake) question:What are your favorite animals? Select as many as applicable:DogsCatsSnakesGuinea pigsOther (includes text box for recording response)

Rudi · Accepted Answer

Hi @echo,this is actually easier than you might think:in the survey flow simple set embedded data fields with the respective selectedChoices (gives back the text as comma-separated string (mind the comma is followed by a blank) and/or selectedChoicesRecodes(gives back a comma-separated string with the recodes of the answers(mind here the comma is also followed by a blank)Please mind that you might run into problems with the text option if:you have multiple languages because the labels in the selected survey language will be written into the embedded data fieldsif the answer items have a comma in the text. if you need to change the format of string you might need to add some java script to manipulate the form of the comma-delimited embedded dataHope this helps, best regardsRudi

echo · Answer

Thank you!

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded