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

    Appended dashes or missing leading 0's (zero) in your Google SpreadSheet? Not any more

    Asked by Ben on January 08, 2015 at 01:26 PM

    Hi,

    Did you have issues with the Google SpreadSheet integration? Our developers just removed 2 of them:

    1. Added dashes (-) in the spreadsheet after submission ID's

    https://www.jotform.com/answers/473921-Google-Drive-sheet-integration-sometimes-adds-after-the-submission-ID#6

    https://www.jotform.com/answers/392513-Google-Spreadsheet-There-s-a-dash-symbol-after-the-submission-ID-number#4

    https://www.jotform.com/answers/440097-Hypen-appears-after-the-Submissions-ID-on-Google-Spreadsheet#4

    - Nope no dashing out on you any more :)

    2. Stripped leading 0's from some fields:

    https://www.jotform.com/answers/453035-If-leading-a-0-in-the-spreadsheet-integration-it-gets-stripped-off-when-data-is-transfered-

    https://www.jotform.com/answers/482933-Leading-0-s-are-stripped-away-in-Google-Spreadsheet-integration#2

    https://www.jotform.com/answers/228901

    - We know that one 0 can make a big difference when numbers are involved and this is now resolved. What you type is what you will get :)

    Before and after:

     

    If you want you can test it by filling out this jotform: http://www.jotformpro.com/form/50074980698972

    and taking a look at this spreadsheet.

    Do test them out and let us know how it goes for you :)

    Google Spreadsheet Submissions Google Integration