What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

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.


  • Profile Image

    Submission date displayed as numbers in Google spreadsheet

    Asked by minoxcz 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
    JotForm Support

    Answered by Kiran 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

    Answered by minoxcz on September 10, 2015 at 05:14 PM

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

  • Profile Image
    JotForm Support

    Answered by Kiran 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

    Answered by marketing952 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?