Delimiter on Jotform for Multiple Select fields

  • Pariti
    Asked on January 16, 2020 at 4:00 AM

    I need to change the delimiter on Jotform for multiple-select fields from ";" to a ",". 


    This is needed due to the fact that I use Zapier to input the content to Airtable which only considers "," as a delimiter. 


    The workaround is to use direct Jotform integration with Airtable however this integration doesn't allow editing existing records and always creates a new record. 


    Does Jotform support either of these two use-cases?

  • Richie JotForm Support
    Replied on January 16, 2020 at 7:16 AM

    We can forward a feature request regarding Airtable.

    Can you please share more information on how you would like the Airtable integration to work with multiple-select fields?

    Looking forward for your response.

  • Pariti
    Replied on January 16, 2020 at 7:39 AM

    Feature Request #1:

    I have a field that asks for the industry experience of people who are filling out the form. People may select multiple industries. The issue is that when people select from a dropdown, the field gets passed using a ";" delimiter. 

    On Airtable, multiple select fields are coded with a "," delimiter instead of ";". So any automation from JotForm to Airtable doesn't work. I am using Zapier for this automation.

    A feature to let people configure the delimiter on Jotform for these fields would solve this issue.


    Feature Request #2: 

    When configuring Jotform to Airtable directly, it is not possible to edit existing records. 

  • Richie JotForm Support
    Replied on January 16, 2020 at 9:20 AM

    I have tested a cloned version of your form and the data in the dropdown field was passed to the Airtable.

    Delimiter on Jotform for Multiple Select fields Image 1 Screenshot 20

    Can you please test our the Airtable integration again?

    Guide:https://www.jotform.com/help/561-How-to-integrate-JotForm-with-Airtable


    For your feature 2, I have moved it to a new thread:https://www.jotform.com/answers/2118973

    Kindly follow the link.

  • Pariti
    Replied on January 16, 2020 at 11:07 AM

    Richie, I am using Zapier for this integration as the existing integration between JotForm and Airtable doesn't meet my needs per Feature Request #2. So I have to use Zapier instead where it's clear that JotForm delimits using ";" instead of ","

  • Richie JotForm Support
    Replied on January 16, 2020 at 12:51 PM

    I have checked with our API and we use comma to set the boundary of a new value in the doprdown field.

    https://api.jotform.com/docs/#submission-id

    Delimiter on Jotform for Multiple Select fields Image 1 Screenshot 20

    Can you please share a screenshot of the delimiter to be semi colon in the dropdown field?

  • Pariti
    Replied on January 16, 2020 at 12:58 PM

    Unfortunately, this doesn't seem to be the case. I pull in the values associated with the field on Zapier and this is how it is shown: 

    1579197376Screen Shot 2020 01 16 at 8 Screenshot 10

    In fact,

    Dropdowns are ";" and Multiple Choice fields are "<br>" as you can see in the picture. No modification was done, this is simply pulling in a new submission directly from Zapier. Could you check how these fields are being passed in the API to Zapier?

  • Richie JotForm Support
    Replied on January 16, 2020 at 2:19 PM

    Thank you for the added information. It seems the issue is with how the submission data is formatted in Zapier to be transferred to Airtable.

    You may try my colleagues work around at this thread:https://www.jotform.com/answers/1469357


  • Pariti
    Replied on January 16, 2020 at 2:53 PM

    Thank you that worked.