Submission date displayed as numbers in Google spreadsheet
-
KiranAnswered on September 10, 2015 at 12:24 PMJotform Support
I've tried cloning your Jotform and integrated Google spreadsheet. When I tried to submit the form, the submission date received on Google spreadsheet is displaying properly at my end. Could you please try removing the Google spreadsheet integration and reintegrate it again to see if that helps?
In order to remove the existing integration, please goto Integrations -> Google Spreadsheets -> Remove Integration.
Also, please check the Locale setting in the Google Spreadsheet settings from File menu and make sure that you are having United States.
Let us know if you need any further assistance. We will be happy to help.
-
minoxczAnswered on September 10, 2015 at 05:14 PM
Thank you very much! I changed settings on US and now it works.
-
KiranAnswered on September 10, 2015 at 06:31 PMJotform Support
Great!! Glad to see that the issue is resolved by changing the locale setting. Please do not hesitate to get back to us if you need any further assistance. We will be happy to help.
Thank you for using Jotform!!
-
marketing952Answered on October 01, 2015 at 05:44 AM
Hi
I have the same problem as minoxcz with the submission date. It worked for several months until now.
However, I don't want to make a new integration since I have formattings and changes in the current spreadsheet. So I'm hoping this is caused by Locale settings or can be solved in some other way.If the problem is the locale settings, should they be United states for me as well who lives in Sweden?