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 time in google spreadsheet is not displayed correctly.

    Asked by asaeboe on April 09, 2015 at 03:10 AM


    I have set up a integration with Google spreadsheet. The data are OK, but the Submission data fails. Instead of a data and time i got a number like this 42103.1234363426. I removed the integration and set it up the integration once again. This solved all the old lines but new submissions are still wrong.


    Any tips to solve this?


  • Profile Image
    JotForm Support

    Answered by ashwin_d on April 09, 2015 at 11:06 AM

    Hello asaeboe,

    I'm sorry for the trouble caused to you.

    I did cloned your form and integrated it with my google account. It seems we are having some issues with the google spreadsheet integration and for me the submission data was not copied to integrated google spreadsheet.

    I would suggest you to please try to re-integrate again see if that solves your problem. I am also reporting it to our back end team. We will get back to you as soon as we have any update from them.

    Thank you!



  • Profile Image

    Answered by Ben on April 09, 2015 at 01:10 PM

    Please try to recreated the integration by:

    1. removing the current integration
    2. recreating the Google SpreadSheet integration

    Once you do, the issue should be resolved, but please do let us know if by some chance it is not.