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

    Google Spreadsheet shows whole numbers instead of dates in the date fields

    Asked by b.portal on October 21, 2015 at 09:23 AM

    Hi the team ;)

    Unfortunately, the same problem come back since three weeks :(

    I followed the same steps I descrived on this thread, and the result is like that :

    the timestamp displays the date correctly in the existing lines (ancient) after reintegrating,

    the timestamp displays the date correctly since about 1 week for the new entries,

    and the problem come back.

    I've do the steps of reinitialisation two times but doesn't work.

    Can you help me please ?

    Best regards.

    Brice

     

  • Profile Image
    JotForm Support

    Answered by Charlie on October 21, 2015 at 09:29 AM

    Hi,

    Our developers added a new option to avoid conflict on the settings of your Google Spreadsheet and of the integration made. Please remove the integration first.

    After that, re-integrate, but make sure to enable the option "PRE-FORMAT (To prevent spreadsheet locale conflict)".

     

    After that, the date values should come to your spreadsheet with the correct format.

    Do let us know if that works.

  • Profile Image

    Answered by b.portal on October 21, 2015 at 09:33 AM

    Okay Charlie I try it, and I come back if the problem come back.

    Thank you very much for your reactivity ;)

    Brice

  • Profile Image
    JotForm Support

    Answered by Charlie on October 21, 2015 at 10:15 AM

    You are welcome, I'm glad to hear that it helped. Please do update us if the problem persists.

    Thank you.

  • Profile Image

    Answered by b.portal on October 27, 2015 at 09:33 AM

    Sorry to disturb you but I tryed to apply this steps to my others forms, and the option "PRE-FORMAT" disappeared.

    I've try to reintegrate without, but the problem persists...

     

     

     

    An idea ?

    Many Thanks ;)

    Brice

  • Profile Image
    JotForm Support

    Answered by Charlie on October 27, 2015 at 11:23 AM

    Hi Brice,

    Apologies for this. I went ahead and opened a separate thread for that specific problem so that I can escalate it better to our developers. Please refer to this link instead: http://www.jotform.com/answers/690923/. I have responded to your inquiry there.

    Hopefully when the "Pre-format" option is available to be used the problem in the dates in the Google Spreadsheet will also be resolved.

    Apologies for the inconvenience.