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

    Incorrect DateTime value in Google Spreadsheet Integration

    Asked by xumanudi on April 30, 2015 at 09:03 AM

    in Google SpreadSheets 

    date error

    I just remove and add the integration.

    30-04-2015 09:14:09 30-04-2015
    30-04-2015 09:14:20 30-04-2015
    30-04-2015 09:15:37 30-04-2015
    30-04-2015 09:16:20 30-04-2015
    30-04-2015 09:16:59 30-04-2015
    30-04-2015 09:18:04 30-04-2015
    01-01-1970 00:00:00 01-01-1970
    01-01-1970 00:00:00 01-01-1970
    01-01-1970 00:00:00 01-01-1970
    01-01-1970 00:00:00 01-01-1970

     

     

    In JotForm the answers is correct

    Excel exported from JotForm is correct

     

     

     

    Screenshot
    JotForm excel table and
  • Profile Image
    JotForm Support

    Answered by Charlie on April 30, 2015 at 11:06 AM

    Hi,

    I've cloned your form and made a test integration to Google Spreadsheet, unfortunately, I can't seem to replicate the problem.

    Could you try the following:

    1. Remove the integration.

    2. Clear your form's cache and your browser's cache. Refresh the page and log back in.

    3. Before re-integration, re-select the Timezone and the Time Format in your account settings.

     

     

    4. After that, try re-integrating the Google Spreadsheet again, make sure to log in your account.

     

    See if that resolves the problem. We'll wait for your response.

    Thank you.