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

  • Profile Image
    FridaHelena
    Asked 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?

  • Profile Image
    ashwin_d
    Answered 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
    FridaHelena
    Answered 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
    nsgtruck
    Answered 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
    FridaHelena
    Answered on April 17, 2015 at 10:21 AM

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

  • Profile Image
    Jeanette
    Answered 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
    FridaHelena
    Answered 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
    ashwin_d
    Answered 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
    FridaHelena
    Answered on April 20, 2015 at 08:10 AM

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

  • Profile Image
    alp_deniz
    Answered on April 21, 2015 at 12:00 AM

    Hello,

    Thank you very much for letting us know.

    All the best