-
SDFFormsAsked on May 10, 2018 at 2:38 PM
I have a form (https://www.jotform.com/build/81295391855164#preview). I am using zapier to write parts of the submision to airtable. Right now Jotform outputs with a semicolon.
Desired end result: Concat the results of a multiple choice with a comma separator when there is value present.
1. Field Why do you want this dog? Is there a way to separate with a comma?
2. An attempted work around. Field How did you hear about Streetdog Foundation? Made of individual check box fields. I can concat with comma but it will do so even when the field is not populated. (ie. Facebook,,,Word of Mouth)
-
Vanessa_TReplied on May 10, 2018 at 4:55 PM
1. Unfortunately Zapier's integration with JotForm is specifically designed to concat multiple choice values by semi-colon in order to cater other major integration, which if not by semicolon would then fail. ie (JotForm - Zapier - Salesforce).
2. As far as I've gathered, you are able to concat fields by comma when setting up your Zap in Zapier.
This however is already on Zapier as it is on their system on how they would treat empty values. I would suggest to drop them a message requesting the feature. https://zapier.com/app/contact-us
-
Vanessa_TReplied on May 10, 2018 at 5:54 PM
As a workaround though, you may use condition to copy a multiple choice field value into a hidden text field. The value then on the text field will be the one you point to in your Zapier setup.
1. Create a text field and make it hidden (my example below is shown for testing purposes)
2. Add a condition under settings tab that IF multiple choice field is FILLED, COPY multiple choice field value to text field.
3. Edit your Zap in Zapier, change the field to point to the text field and NOT the multiple choice field.
-
SDFFormsReplied on May 14, 2018 at 3:04 PM
Vanessa_T bless you! Simple, no extra usage with AT and worked perfect! Thanks so much!