Google Spreadsheet integration records date or datetime values as a whole number

  • oswaldocruzquimica
    Asked on November 3, 2015 at 10:27 AM

    Hello Kemalo

     

    My problem return to happen, would you mind helping me?


    It´s same problem, i put the right configuration, but when the integration with JotForm and Google sheets, happen the date is filled wrong.

     

    Regards.

    Dener Leão

  • Welvin Support Team Lead
    Replied on November 3, 2015 at 10:51 AM

    Hi Dener,

    Did you try my previous suggestion on September 09, 2015 to manually set the "Locale"? Here's the link to my reply: https://www.jotform.com/answers/657256#658107.

    Now, if that is not working, please try to re-integrate the form again to Google Spreadsheet and this time, please check the option to Pre-Format the date field.

    Google Spreadsheet integration records date or datetime values as a whole number Image 1 Screenshot 20

    Thanks

  • oswaldocruzquimica
    Replied on November 3, 2015 at 12:06 PM

    Hello, Kemalo

     

    Thank you so much.

     

    I apply this sugestion, and now thaa`s ok.

     

    Thank you a lot.

     

    Regards.

    Dener Leão

  • Welvin Support Team Lead
    Replied on November 3, 2015 at 2:22 PM

    That's great to know! Please contact us again if we can help in any way.

    Thanks