- FridaHelenaAsked 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?
- JotForm Supportashwin_dAnswered on April 16, 2015 at 12:23 PM
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.
- FridaHelenaAnswered 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:
- nsgtruckAnswered 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.
- FridaHelenaAnswered on April 17, 2015 at 10:21 AM
For me, changing the Regional setting, didn't change anything.
- JotForm Support ManagerJeanetteAnswered on April 17, 2015 at 12:34 PM
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.
- FridaHelenaAnswered 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.
- JotForm Supportashwin_dAnswered on April 20, 2015 at 04:17 AM
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.
- FridaHelenaAnswered on April 20, 2015 at 08:10 AM
If I disable autoCrat auto-run (run it manually works) the date is correct.
- alp_denizAnswered on April 21, 2015 at 12:00 AM
Thank you very much for letting us know.
All the best