Zapier Integration (JotForm -> Airtable): Concat multiple choice values by comma instead of semi-colon

  • SDFForms
    Asked 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_T
    Replied 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.

    Zapier Integration (JotForm  > Airtable): Concat multiple choice values by comma instead of semi colon Image 10

    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_T
    Replied 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 FILLEDCOPY 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.

    Zapier Integration (JotForm  > Airtable): Concat multiple choice values by comma instead of semi colon Image 10


  • SDFForms
    Replied on May 14, 2018 at 3:04 PM

    Vanessa_T bless you! Simple, no extra usage with AT and worked perfect! Thanks so much!