Submission date displayed as numbers in Google spreadsheet

  • minoxcz
    Asked on September 10, 2015 at 11:32 AM
    1) I want to use Google spreadsheet integration, but I have a problem with broken "submission date", there is a random number (attach pictures).
  • Kiran Support Team Lead
    Replied on September 10, 2015 at 12:24 PM

    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.

  • minoxcz
    Replied on September 10, 2015 at 5:14 PM

    Thank you very much! I changed settings on US and now it works.

  • Kiran Support Team Lead
    Replied on September 10, 2015 at 6:31 PM

    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!!

  • marketing952
    Replied on October 1, 2015 at 5: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?