JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
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.
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?
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.
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:
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.
For me, changing the Regional setting, didn't change anything.
JotForm Support Manager
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.
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.
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.
If I disable autoCrat auto-run (run it manually works) the date is correct.
Thank you very much for letting us know.
All the best