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

    Submission date format is not being displayed in integrated google spreadsheet.

    Asked by Vladimir on April 21, 2015 at 12:50 AM

    Hello!

    When I set syncronization my JotForm with my google spredsheets to ON, I have a problem with field type "date".

    For example in table jotform I see "20.04.2015 21:58:34", but after sync in my google table  I see strange text "42115.481111111".

    What is it? Please, help.

    Page URL:
    http://www.jotformeu.com/form/30344345627351

    table JotForm problem style size
  • Profile Image
    JotForm Support

    Answered by ashwin_d on April 21, 2015 at 08:10 AM

    Hello Vladimir,

    I'm sorry for the trouble caused to you.

    We did have some issue with the submission date format in google spreadsheet but as per our developer, the issue was resolved already.

    Can you please check your google spreadsheet locale settings and see if you have made any changes there. Locale setting of google spreadsheet can be checked through "File ->> Spreadsheet Settings". If you make any changes in your spreadsheet locale setting, it will cause all the formatting to reset.

    I would suggest you to please revert back your google spreadsheet locale setting and then re-integrate your form with google spreadsheet.

    Do get back to us if the issue persists and we will report it to our back end team.

    We will wait for your response.

    Thank you!