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

    Date field data are not showing correctly in Google Spreadsheets.

    Asked by sethr on December 18, 2016 at 06:27 AM
    the submission date & another date field (tanggal presentasi) in my forms showed incorrectly in my google spreadsheet, what happened? 
  • Profile Image
    JotForm Support

    Answered by Mike_G on December 18, 2016 at 07:12 AM

    By default or when you integrate your form with Google Spreadsheet, it should show you the correct format of the date fields in the spreadsheet.

    However, in your case, it's possible that the format was changed for some reason.

    To change it back, select the column that you would like to change (please do not include the headers) then click "Format" from the spreadsheet's menubar, go to "Number", and select the appropriate format for that specific column.

    You can also try to reintegrate (remove integration from present integration and integrate again) your form with Google Spreadsheet using the same Google Account. It would, however, become a different spreadsheet already and connections with earlier integrations will be lost.

    I hope this helps. If you need any further assistance regarding this, please feel free to follow up on this thread and we will be glad to help you.

    Thank you.

  • Profile Image

    Answered by sethr on December 18, 2016 at 07:31 AM

    Thank you so much! I'll try it