What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.

  • Profile Image

    If leading a "0" in the spreadsheet integration it gets stripped off when data is transfered.

    Asked by deakintezet on November 02, 2014 at 12:30 PM

    I tried the same as you write it, no results... I got the numbers without zero... this is the form: http://form.jotformeu.com/form/40973466690364?

    The field is called: "Mobilszám"

  • Profile Image

    Answered by Shadae on November 02, 2014 at 02:05 PM

    Hi deakintezet,

    The current entries in your Google SpreadSheet would not add the zero. It will only show up for new submissions once the change has been made.

    Are you still having the issue with new submissions?

    We await your response to better assist you. Thank you.

  • Profile Image

    Answered by deakintezet on November 03, 2014 at 04:39 AM

    No, it still cuts the leading zero... :(


  • Profile Image

    Answered by jedcadorna on November 03, 2014 at 06:18 AM

    Try deleting the field "Mobilszám" and adding it back again. It should show the zero's. Please check my sample here.

  • Profile Image

    Answered by deakintezet on November 03, 2014 at 06:34 AM

    changed it but still doesnt work :(

  • Profile Image

    Answered by jedcadorna on November 03, 2014 at 07:15 AM

    I have tested a few submissions and it strips off if submitted a couple of times. Let me forward a ticket to our 2nd level about this issue, but in the mean time please use "Phone Number" field rather than a text box.

    Also, if Phone Picker or Country Code would work for you please try those widgets.


  • Profile Image

    Answered by crosspoint1 on December 28, 2014 at 01:58 AM

    Was there an answer to this?  I am having the same issue.  When integrating with Google Sheets, the leading zeros of a field are being stripped away.  Thanks.
  • Profile Image

    Answered by Ben on December 28, 2014 at 06:55 AM

    Hi @crosspoint1

    There are currently no new updates on this, but I have moved your question to a new thread found here: http://www.jotform.com/answers/482933 where we will be replying back to you shortly and if needed raise you thread to our developers as well so that they can see the number of people being affected by this.

    Best Regards,

  • Profile Image

    Answered by alp_deniz on January 08, 2015 at 12:51 PM


    The issue has just been identified, fixed and notified in the other thread. Please let us know if any problem still exists, we will be very happy to assist you further.

    Thank you very much

    Kind regards