We have a form that has a few questions that are multiple choice, when the form is submitted we want the selections to match the custom fields in ActiveCampaign. There is a native integration which would work, BUT it is only able to be run once per contact and in our situation a contact may enter this form multiple times so I am going through Zapier.
The form is submitted and Zapier parses the data, and I match all the fields. For the multiple choice responses the data comes in as a comma separated list, but to add it to ActiveCampaign the selections need to be double piped (||). I have Zapier replace the comma with the double pipes, but it looks like there is a space left between the responses.
As an example, the data coming into Zapier for a multiple choice response may be Answer A, Answer B, Answer C, Answer D. I then replace the comma with the double pipe so them my data looks like Answer A|| Answer B|| Answer C|| Answer D but this left over space is causing only the first entry to be selected.
I’ve tried using the Zapier function to remove the space but it never seems to “find” a space to remove.