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

  • Profile Image
    deakintezet
    Asked 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
    Shadae
    Answered 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
    deakintezet
    Answered on November 03, 2014 at 04:39 AM

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

    https://docs.google.com/spreadsheets/d/17LcO2s5GMSS2-8wfQl9GQlXh_0dIq42485tUTSy0F4k/edit?usp=sharing

  • Profile Image
    jedcadorna
    Answered 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
    deakintezet
    Answered on November 03, 2014 at 06:34 AM

    changed it but still doesnt work :(

  • Profile Image
    jedcadorna
    Answered 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
    crosspoint1
    Answered 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
    Ben
    Answered 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,
    Ben

  • Profile Image
    alp_deniz
    Answered on January 08, 2015 at 12:51 PM

    Hello,

    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