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

    Dates disappearing in the google spreadsheet

    Asked by ITU_contacts on May 01, 2014 at 09:37 PM

    Somehow the dates are disappearing from 4/28 in the spreadhsheet, help..


    4/28/2014 12:00:11 104018
  • Profile Image
    JotForm Support

    Answered by ashwin_d on May 02, 2014 at 02:16 AM

    Hello ITU_contacts,

    I'm sorry for the trouble caused to you.

    Are you having this problem with your google spreadsheet? I did try to download your submissions in excel and it seems to display the submission date as expected. Please check the screenshot below:

    I would suggest you to please check again and get back to us if the issue persists.

    We will wait for your response.

    Thank you!

  • Profile Image

    Answered by ITU_contacts on May 02, 2014 at 03:30 PM



    The dates are not showing after 4/28, is that a system glitch?

    Yes, I am having trouble with google spreadsheet...

  • Profile Image

    Answered by EliezerN on May 02, 2014 at 04:57 PM

    Thanks for the clarification.

    Probably the integration got currepted somehow and the dates are no longer accepted, or the format of your column changed so it is not compatible with the date format anymore.

    Could you please confirm if this is the form you are having problems with? http://www.jotform.us/form/40776114380149

    I cloned it, integrated it with google spreadsheet and then sent some submissions, but everything went through just fine: 

    So, we recommend you to remove the current integration and re-add it, it should display the dates. To remove the current integration simply go to Setup & Embed > Integrations > Google Spreadsheet and then click on Remove integration:

    Inform us if the issue still persists.