-
ParitiAsked 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 SupportReplied 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.
-
ParitiReplied 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 SupportReplied 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.
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.
-
ParitiReplied 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 SupportReplied 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?
-
ParitiReplied 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:
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 SupportReplied 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
-
ParitiReplied on January 16, 2020 at 2:53 PM
Thank you that worked.