Delimiter on Jotform for Multiple Select fields

  • Profile Image
    Pariti
    Asked on January 16, 2020 at 04: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?

  • Profile Image
    Richie_P
    Answered on January 16, 2020 at 07: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.

  • Profile Image
    Pariti
    Answered on January 16, 2020 at 07: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. 

  • Profile Image
    Richie_P
    Answered on January 16, 2020 at 09:20 AM

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

    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.

  • Profile Image
    Pariti
    Answered 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 ","

  • Profile Image
    Richie_P
    Answered 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

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

  • Profile Image
    Pariti
    Answered 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.53

    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?

  • Profile Image
    Richie_P
    Answered on January 16, 2020 at 02: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


  • Profile Image
    Pariti
    Answered on January 16, 2020 at 02:53 PM

    Thank you that worked.