- MartyinGammonAsked on November 11, 2014 at 12:07 PM
I use JotForms to collect data for bookings. Zapier then transfers this information to another API connected to my company database.
Zapier successfully reads all the information except the telephone number with is being picked up as "N/A". Zapier have confirm this is how it is coming from JotForm.
Can you help, please?
- ShadaeAnswered on November 11, 2014 at 01:06 PM
I do apologize for the issue that you are experiencing with your integration to Zapier.
To confirm, you have been able to Map the Telephone field, however the information does not get transferred to Zapier?
I am seeing that all of the phone numbers submitted, start with "0", could you do a few test submissions, using phone numbers, without the zero in front and inform us, if the information is still not being passed.
If it is still not passed, can you please try to re-create the current integration with Zapier to attempt to resolve the issue.
We await your updated response. Thank you.
- MartyinGammonAnswered on November 11, 2014 at 02:38 PM
Thanks for your reply.
I tried several things with the existing field, including sending a number without a leading zero and a simple alpha text with no numbers. All were passed to Zapier as N/A.
So next, I created another field in the form and made the original invisible. This has solved the problem and Zapier now reads the number from the NEW field. The old field still returns N/A.
So, I now have a way to collect the phone number info. I will keep the old field (hidden on the form) as it has phone number data in it.
Sorry I cannot provide any more clues about what may have happened.
- BenAnswered on November 11, 2014 at 04:10 PM
Usually the integrations do not pick up the the phone number if you are using textbox tool (under Form Tools) instead of the phone tool (under Quick tools).
This is the same with Address, Full Name and E-Mail tools.
Now if you did not get any submissions so far, you should be able to delete the old field for phone and add a new one that is called in the same manner and you should still be able to see the submissions in your submissions report.
I would also suggest clearing out your jotforms case: Clear form cache in case you start having any further issues.
- MartyinGammonAnswered on November 12, 2014 at 04:01 AM
Thanks for your reply. I did see the Quick Tools, but they are quite specific to the USA and I am based in the UK. If on the address field, for example, I could rename or hide individual elements (eg rename State/Province or hide Country) that would be very useful. Likewise for the telephone number field, being able to combine into one field would be good.
I will take your advice about the cache and keep an eye on the form. Overall, I am very impressed with JotForm (particularly the new designer view). I use it in Adobe Muse web sites and it's much better than the native tools.
- JotForm SupportWelvinAnswered on November 12, 2014 at 07:17 AM
You can combine Phone Number field into one by enabling Input Mask to it:
Enabling Input Mask allows you to setup phone number that requires a specific format. You may consider trying that as well.
Maybe, you can setup a different form and use it or clone your existing form and do the changes there. Here's how you can copy an existing form from your account: https://www.jotform.com/help/27-How-to-clone-an-existing-form-from-your-account.