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

    Format Submissions Date on Google Spreadsheet Integration

    Asked by shelleykim on November 05, 2013 at 02:05 PM

    I just used the app to populate all the submissions for my form on a Google Spreadsheet. However, the date is coming out as day/month/year. I've tried to reformat this on the Google Spreadsheet to reflect the format of month/day/year but it doesn't work. Any suggestions? 

    Thank you!

    Submissions app format doesn't work
  • Profile Image

    Answered by EliezerN on November 05, 2013 at 03:31 PM

    Thanks for contacting us.

    Is this the form you are talking about https://www.jotform.com/33075478854162? I found that you have the correct date format (mmddyyyy) in the form:

    I cloned your form and built the integration, then sent a submission and the google spreadsheet does not recognize that format as a date:

    Is that the way you are getting this error? or does the google calendar pop-up when you click on the date? If you get the error in the same way I do, that requires us to forward this issue to our next level support.

    So, please let us know so tha we can forward this issue to our next level support.

    Thanks

  • Profile Image

    Answered by shelleykim on November 05, 2013 at 04:15 PM

    Hi,

    Thanks for the response. Yes, that is the form I was talking about. However, the only thing I have a problem with is the Submission date for the first column in the Google Spreadsheet. If I submit something on my form today, it comes out as 5/11/2013. Any way to fix that? Thank you!

  • Profile Image
    JotForm Support

    Answered by EltonCris on November 05, 2013 at 10:13 PM

    @shelleykim 

    I am able to reproduce the problem. This might be due to the changed made on the mentioned integration. I am not sure if the date format is possible on the integration though but I will have to forward this to our developers for further investigation.

    As a workaround and while waiting for a solution, please use a calendar field (date/time) field for now in order to get the desired date format on every submissions.

    Thanks!

  • Profile Image

    Answered by portoakaland on November 05, 2013 at 10:26 PM

    How do I get answer to the question ipost on the forum quickly?  I need help ASAP.

  • Profile Image
    JotForm Support

    Answered by EltonCris on November 05, 2013 at 10:30 PM

    @portoakaland

    If you have similar question about this, please open it on a new thread so we can handle and provide you updates on your threads. We will also respond to your threads shortly.

    Thanks for your understanding!

  • Profile Image
    JotForm Support

    Answered by alp_deniz on November 06, 2013 at 10:15 AM

    Hello,

    Submission date is now shown as you like (mm/dd/yyyy). Please let us know if you have further feedback.

    Best