I have a multi-select checkbox question on a SurveyMonkey survey and want to map its contents to the same options on a muti-select checkbox field in ActiveCampaign. Unfortunately, one of the options has an answer like “Green (Blue, Yellow)” (i.e., it has commas, and they’re inside parentheses). It appears that the commas are throwing off the ability for this to map to the field option. Since this runs through Zappier to get to AC, I’ve tried multiple variations (replacing commas with double pipes, removing quotes, removing parentheses, etc.). Still, I can’t get it to check that checkbox. (All the other checkboxes on the same field work–just not the one with commas in the answer.) Any suggestions?
Hey @excellenceined have you tried putting the double pipes around the values themselves? So in your example, you would import the value into ActiveCampaign as:
||Green (Blue, Yellow)||
Got the idea from this documentation for the Google Sheets integration.
Yes, but it still doesn’t select the checkbox. 