-
Green_WalkerAsked on September 22, 2022 at 3:56 PM
Hello
We currently have an integration setup to send jotform responses for this form: https://form.jotform.com/222136252535146
We capture City and State as two fields for a persons address. Something is going wrong with the integration where jotform is sending City data into our State field.
Here is a screenshot of the entry i just logged with a City of san francisco and a State of CA
Here is a screenshot of the integration data mapping between Jotform and Airtable that we set up here: https://www.jotform.com/build/222136252535146/settings/integrations You can see we have mapped City and State together between Jotform and Airtable
Heres how the data then shows up for us in Airtable. You can see City data has been mapped to city and state
This is pretty ugly and would love some support to get fixed asap
-
Sigit JotForm SupportReplied on September 22, 2022 at 5:06 PM
Hello Green_Walker,
Thank you for reaching out to Jotform Support. Please allow me some time to check and test this. I will get back to you as soon as I have more information.
We appreciate your patience and understanding as we look into this further.
-
Sigit JotForm SupportReplied on September 22, 2022 at 5:20 PM
Hello Green_Walker,
Thank you for your patience. We’re sorry you're having difficulties with this. I cloned your form and tested it to see if I could replicate the issue, I ran into the same problem, so I created a ticket and escalated this to our Developer team.
On Jotform Tables:
Jotform AirTable Integration, mapped City and State together between Jotform and Airtable:
Data passed to AirTable, City data has been mapped to city and state:
Although we don't know exactly when the issue will be fixed, we’ll circle back to this thread when we have an update.
Thanks for your patience and understanding, we appreciate it.
-
Green_WalkerReplied on September 23, 2022 at 7:08 PM
Hi thanks for looking into this!
Is there any way to know if this is something that will be taken care of in a week/2 weeks/or a month? Depending on timeline, would just need to know if we need to find workarounds on our end
-
Annaliza_O Jotform SupportReplied on September 23, 2022 at 7:20 PM
Hi Green_Walker,
Thank you for reaching out to Jotform Support. We cannot provide the exact date. Rest assured that our Developers are working on this as fast as they can. As soon as we have an update, we'll let you know.
-
Green_WalkerReplied on September 28, 2022 at 12:37 PM
Hi - any updates on this?
-
Sigit JotForm SupportReplied on September 28, 2022 at 12:46 PM
Hello Green_Walker,
Unfortunately, I don’t have an update yet. I know that it’s taking some time to resolve and that is very stressful. I’ve marked this as a Priority and reached out to our Developer Team again.
We’ll let you know as soon as there is an update. Thanks for your patience and understanding.
-
oykudanisik Jotform SupportReplied on October 3, 2022 at 3:47 PM
Hello Green_Walker,
Thank you for your patience. I looked at your form and integration.
I noticed that the Unique Name of 3 of your fields City, State, and Zip Code are the same. When you have the same Unique Name for the fields, the system cannot differentiate these fields. If you change these names to unique names your integration should be working the right way. You can find screenshots down below about how to change Unique Name values of your fields.
Please try it and let us know if the issue still persist or if you need any further assistance.
Thanks.
-
Green_WalkerReplied on October 3, 2022 at 5:23 PM
Hi this resolves the issue, but given that unique name wasn't something we even knew about before this ticket, the error where the unique name became the same for those three fields must have come from jotform's side. Is anyone looking into how that happened?
-
Annaliza_O Jotform SupportReplied on October 3, 2022 at 7:10 PM
Hi Green_Walker,
Thanks for reaching out to Jotform Support. Please allow me some time to check this with our Developer Team. In the meantime, you can try the workaround that they provided.
We’ll let you know as soon as there is an update. Thanks for your patience and understanding.