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.
Format Submissions Date on Google Spreadsheet IntegrationAsked 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?
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 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!
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.
How do I get answer to the question ipost on the forum quickly? I need help ASAP.
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!
Submission date is now shown as you like (mm/dd/yyyy). Please let us know if you have further feedback.