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

    Submissions date appears as numbers on Google Spreadsheet

    Asked by marketing952 on October 01, 2015 at 08:52 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?

    locale correct date numbers date as numbers numbered date numbers date google spreadsheet
  • Profile Image
    JotForm Support

    Answered by EltonCris on October 01, 2015 at 09:06 AM

    Hello,

    I have moved your question to a separate thread here.

    Yes that's indeed due to the locale settings. There are two possible solutions.

    1. Change your spreadsheet locale settings to US. Here's how:

       a. Open the integrated spreadsheet

       b. Click File > Spreadsheet Settings

        c. Set US on Locale

    2. By re-integration which seems to be not your option. But anyway, if in case you want to re-integrate, simply check the Pre-format found on the Google Integration Wizard as you move along the steps, this will resolve the problem.

  • Profile Image

    Answered by marketing952 on October 01, 2015 at 11:11 AM

    Thank you

     

    That seemed to solve the problem for future inputs!

    Do you know if the Locale change from Sweden to US will affect anything else?
  • Profile Image
    JotForm Support

    Answered by KadeJM on October 01, 2015 at 01:21 PM

    On behalf of Elton you are very welcome and we're glad to hear that worked out for you.

    I have split your follow-up question into a new thread as a separate topic found here.