Submission date displayed as numbers in Google spreadsheet

  • Profile Image
    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).
  • Profile Image
    Kiran
    Answered 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.

  • Profile Image
    minoxcz
    Answered on September 10, 2015 at 05:14 PM

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

  • Profile Image
    Kiran
    Answered on September 10, 2015 at 06: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!!

  • Profile Image
    marketing952
    Answered 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?