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 in google spreadsheet is not being displayed in proper format.

    Asked by FridaHelena on April 16, 2015 at 09:05 AM

    I have a form created with jotform. I've connected it with a google spreadsheet and the connection works fine. But, the Submission Date gets wrong.

    Some examples:
    2015-04-16 14:13:20 becomes 9918653:13:00.000
    2015-04-16 14:16:57 becomes 9960512:47:00.000
    2015-04-16 14:24:31 becomes 10048089:56:00.000

    This causes problem with an extension that I have in my spreadsheet. I've tried to delete the connection with the file and set it up all over but the problem is still there.

    How can I solve this?

    Page URL:
    https://www.140kvadrat.se/solskydd/markiser/markisvav

    problem JotForm style size
  • Profile Image
    JotForm Support

    Answered by ashwin_d on April 16, 2015 at 12:23 PM

    Hello FridaHelena,

    I'm sorry for the trouble caused to you.

    We did have some issue last week with the submission date in google spreadsheet but as per our developer, the issue is already resolved. You should not have any issue. 

    I am not sure what is causing this issue but when I cloned your form and integrated it with my google spreadsheet account, it seems to work as expected. Please check the screenshot below:

    I would also suggest you to please check your google spreadsheet locale settings and see if you have made any changes there. Locale setting 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. Please check and revert back any local setting you have in your google spreadsheet and see if that resolves your problem.

    Do get back to us if changing locale does not resolves this issue and we will report it to our back end team.

    Thank you!

  • Profile Image

    Answered by FridaHelena on April 17, 2015 at 02:45 AM

    I just re-tested to submit the form and the date is not displayed correct. I took printscreens of both the date and my settings (sorry, they are in swedish). Se below:

  • Profile Image

    Answered by nsgtruck on April 17, 2015 at 08:38 AM

    FridaHelena is on to something. I have Norwegian as regional settings and I have the same problem. if I switch to Great Britain the problem disappears, but I get a slightly different timeformat on the submissions.

  • Profile Image

    Answered by FridaHelena on April 17, 2015 at 10:21 AM

    For me, changing the Regional setting, didn't change anything.

  • Profile Image
    JotForm Support Manager

    Answered by Jeanette on April 17, 2015 at 12:34 PM

    @FridaHelena

    You should re-build the integration to see the changes to take effect.

    At any rate, I'm forwarding this to our developers to see if something can be done for these particular regions.

  • Profile Image

    Answered by FridaHelena on April 20, 2015 at 02:35 AM

    I think I found the problem!

    I'm using a plug-in called autoCrat to merge rows in my spreadsheet with a Google Document. Seems that if I had it to auto-run it messed upp my spreadsheet.

  • Profile Image
    JotForm Support

    Answered by ashwin_d on April 20, 2015 at 04:17 AM

    Hello FridaHelena,

    I am glad to know that you figured our the issue yourself. 

    Does that mean that disabling the autoCrat add-on resolved your issue? Please confirm if the google spreadsheet is displaying the submission date correctly.

    Thank you!

  • Profile Image

    Answered by FridaHelena on April 20, 2015 at 08:10 AM

    If I disable autoCrat auto-run (run it manually works) the date is correct.

  • Profile Image
    JotForm Support

    Answered by alp_deniz on April 21, 2015 at 12:00 AM

    Hello,

    Thank you very much for letting us know.

    All the best