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

  • b.portal
    Asked on October 21, 2015 at 9: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

     

    Google Spreadsheet shows whole numbers instead of dates in the date fields Image 1 Screenshot 20

  • Charlie
    Replied on October 21, 2015 at 9: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)".

    Google Spreadsheet shows whole numbers instead of dates in the date fields Image 1 Screenshot 20

     

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

    Do let us know if that works.

  • b.portal
    Replied on October 21, 2015 at 9:33 AM

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

    Thank you very much for your reactivity ;)

    Brice

  • Charlie
    Replied 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.

  • b.portal
    Replied on October 27, 2015 at 9:33 AM

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

    Google Spreadsheet shows whole numbers instead of dates in the date fields Image 1 Screenshot 30

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

     

     

    Google Spreadsheet shows whole numbers instead of dates in the date fields Image 2 Screenshot 41

     

    An idea ?

    Many Thanks ;)

    Brice

  • Charlie
    Replied 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.