JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
Problem with Google Sheets, dd/mm format go to mm/ddAsked by leo8nardo8 on December 28, 2015 at 07:39 AM
I'm having this problem
This is in the JotForm Answer
And in the Google Sheets, this date come like this
In my form, the date format is set DD/MM/YYYY, and all the submissions are OK, but in the Sheet i'm having this format problem.
How can I solve this?
Sorry for this inconvenience. I have just cloned your form and was not able to recreate your issue. Could you please try to re-integrate your spreadsheet and see if this resolves the issue.
If you still experience this issue, please let us know and we will be glad to take another look.
I try to re-integrate my spreadsheet and I didn't have the same issue.
Glad to hear that re-integrating resolves your problem. Should you need any assistance again, feel free to contact us here in the forum.
I have already re-integrate 3 times my sheet.
Every time I re-integrate the problem is solve, but when I get new submissions this erros repeat.
Look at the last answer, they come with a diferent format, and this cause me problens in others sheets.
What should I do?
It could be that the format of the spreadsheet is not the correctformat and it needs to be changed, or you can change the format of your date fields to mmddyyyy.
This should change the fields automatically to the proper format.
Thanks, it works!!
On behalf of my colleagues who helped you with your concern, you're most welcome! Feel free to contact us anytime if you have any other questions or concerns. Thank you.
Guys everytime I get new submissions I'm geting problems.
They with 3 diferente format, and I cannot correct.
Before the integrate they come with the format dd-mm-aaaa hh:mm:ss
After integrate 5 submissions come with MM/DD/aaaa hh:mm:ss
And the last 3 come tiwh DD/MM/AAAA hh:mm:ss
Same thing in another column
Before integrate dd/mm/aaaa
After integrate 4 with dd/mm/aaaa
3 with mm/dd/aaaa
1 with dd/mm/aaaa
Help pls :)
Sorry for this inconvenience. I have retest the integration and was not able to replicate the issue. Could you please indicate if this occurs randomly, at certain times, and with the format already set.
I will submit forms for a couple of hours and see if I can replicate the issue. If I'm able to replicate the issue, I will keep you informed.
When I re-integrate the form all the "past" date come with the same format. But after the re-integrate when I get new submissions the format os dates changes.
It seems to be randomly. I tried to set the format to the cells, but didn't work to me.
Thanks for the help.
Thank you for the update. Like I mentioned, I will be tested on the course of the day. At the moment I have submitted forms but was not able to replicate the issue you are having.
I have played with the format in the spreadsheet, but it does not change when I submit the form. If I find anything, I will let you know.
Sorry for not getting back you sooner. I have been testing the spreadsheet integration. At the moment I was not able to replicate the issue you are having. I have modified the format many times as well as remove and integrated the spreadsheet.
The dates are always entered in the same format.