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

    How do i remove the time from the date field in the google spreadsheet integration

    Asked by paul.armsby on January 21, 2014 at 09:39 AM
    date field
  • Profile Image

    Answered by Cesar on January 21, 2014 at 10:07 AM

    If you do not need the time value on the DateTime field. You can always remove it form the field itself by, clicking the fields gear icon (Properties) and setting "Allow Time" to No, like so:

    https://cms.jotform.com/uploads/image_upload/image_upload/global/23768_dt.jpgo

    https://cms.jotform.com/uploads/image_upload/image_upload/global/23769_dt2.jpg

    Do let us know if you need further assistance on this.

     

  • Profile Image

    Answered by paul.armsby on January 21, 2014 at 10:20 AM
    Hi
    This only applies to the information typed into the form, the issue is that
    jotform still sends through a time in the date field when populating google
    spreadsheets.
    Thanks
    Paul
    ...
  • Profile Image

    Answered by Cesar on January 21, 2014 at 10:52 AM

    Thank you for your input. Do make sure to also have your Google Spreadsheet propely formatted.

    Meaning the date column should have the following format, kindly selct the column on your google spread sheet and apply the date format as so:

    https://cms.jotform.com/uploads/image_upload/image_upload/global/23772_formatcondition.jpg

     

    Do let us know if you need further assitance. Thank you.