Date field data are not showing correctly in Google Spreadsheets.

  • sethr
    Asked on December 18, 2016 at 6:27 AM
    the submission date & another date field (tanggal presentasi) in my forms showed incorrectly in my google spreadsheet, what happened? Date field data are not showing correctly in Google Spreadsheets Screenshot 20
  • Mike_G JotForm Support
    Replied on December 18, 2016 at 7: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.

    Date field data are not showing correctly in Google Spreadsheets Screenshot 30

    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.

    Date field data are not showing correctly in Google Spreadsheets Screenshot 41

    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.

  • sethr
    Replied on December 18, 2016 at 7:31 AM

    Thank you so much! I'll try it