- steelneil81Asked on August 29, 2012 at 08:50 AM
Is it possible to change the date format when integrating to Google Docs?
I have a JotForm that feeds info into a Google Spreadsheet which then feeds a comments board on my Google Site. Everything works great except the date does not get recognised in my comments board as it is not a true date format (I'm assuming it is reading it as text raher than a date and time).
Is there any fix for this?
- JotForm SupportEduardoMendezAnswered on August 29, 2012 at 10:03 AM
Hi steelneil81, can you please provide us with the form URL to further assist you. Thanks!
- JotForm SupportNeilVicenteAnswered on August 29, 2012 at 12:58 PM
The submission date column is actually formatted as Date and Time. However, if you'd like to make sure, simply format the said column as you wish.
1. Add more rows to allow to have future submissions formatted as well
2. Click on the column header
3. Click the 123 button then choose the Date Time format
- steelneil81Answered on August 31, 2012 at 07:44 AM
My form is www.jotform.com/form/10642815064
I have tried setting the format within Google Docs but it appears to make no difference to the formatting created by JotForm. It is almost like it is a text input rather than a date input.
I have a couple of submissions from this form, the Google Docs listed them as MM/DD/YYYY HH:MM:SS. however, when I changed the format to DD/MM/YY (UK setting in the Google Spreadsheet) in Google Docs the format remains MM/DD/YYYY HH:MM:SS
- jeanettebmzAnswered on August 31, 2012 at 04:41 PM
That is known glitch in Google spreadsheets that is apparently fixed, please follow these steps:
Go to File > Spreadsheet settings... and change the Locale: to your location
If you are still unable to change the date to UK format , you should contact Google docs support
- steelneil81Answered on September 06, 2012 at 09:05 AM
But surely the issue is with JotForm as this is the source of the information.
- fxrAnswered on September 06, 2012 at 07:02 PM
JotForms servers are in the US format. We cant really change those date format settings on a per user basis.
- stevenyilinAnswered on October 07, 2012 at 02:55 PM
i ve tried all sorts of things- changing setting to US. clicking on the submission date row and selecting the format YYYY-MM-DD
it just doesnt work.
surely this error must be on JF side.
cause the entrees are listed just fine on the JF database with the newiest at the top!
- JotForm SupportRodjitAnswered on October 07, 2012 at 03:44 PM
I have tried it on my end and all are working, please check back your settings and follow instructions by our Manager Jeanette and my colleague NeilVicente.
- richiesta_ferieAnswered on October 22, 2012 at 11:07 PM
I have the same problem and have all setted, without viewing this post.
My Locale is italian and Google GMT for Italy is +1:00.
Well, what I noticed is a difference in punctuation:
JotForm format is mm/dd/yyyy hh:mm:ss
Google locale format is dd/mm/yyyy hh.mm.ss
So this is why we can't get a correct date format at all.
And That's All Folks
[I mean that locale format is not compatible with a correct date format : injecting a hh:mm:ss format, forces Google file to think this is not a date field and consequently not to change the format
ACTUAL SOLUTION (not mine): get back to US locale
OTHER SOLUTION: improving forms with separators choice]
- jeanettebmzAnswered on October 22, 2012 at 11:34 PM
Thank you for your observations and for suggesting a workaround
I am forwarding your comments to our developers , so they might check and advise further
- richiesta_ferieAnswered on October 22, 2012 at 11:36 PM
really pleased Mrs. Jeanette
- richiesta_ferieAnswered on October 23, 2012 at 10:23 AM
I would like to add that such behaviour is not limited to the submission's field.
It looks like the date picker's field is affected as well. It is not evident because its format is dd-mm-yyyy hh:mm:ss.
And this is my tryout
It seems to work well without hh:mm and suggests a workaround and test it as hidden field for submissions.
As you can see, disabling time seems to force a new behaviour: the slashes have appeared in date picker's field.
Don't care about 0.00.00 'cause I setted the column as Date and Hour Format and disabled Time on my form.
- guest_30052210569040Answered on January 07, 2013 at 03:08 AM
- guest_30052210569040Answered on January 07, 2013 at 03:12 AM
I have the same problem with the date format for "submission date", but ...
it worked well on older forms of December 2012.
Let me explain :
before sending a first recording and after the integration of a form in Google spreadsheet
=> I changed the settings area on spreadsheet => France, GTM +1 ...
and the date is converted to the well area.
Now, I come to create a new form and after several attempts ... it does not work properly???
Apparently Date Format is not known, as it is very well explained here
This is very annoying and a shame because everything else works really well.
Is that a solution has been found?
Thank you in advance
- JotForm SupportidarktechAnswered on January 07, 2013 at 06:41 AM
The problem is still in the request list. Unfortunately we can not provide ETA to when this will be fixed. Rest assured, you'll be informed via this thread once it is corrected.
- stevenyilinAnswered on January 13, 2013 at 01:06 PM
though its taking quite long i am assured you guys can handle it.
... cause jotform is THE BEST! ;))
- nicolasfranco0Answered on December 03, 2013 at 06:55 AM
Hi. I seem to have the same problem of format of submission date in Google docs integration... But i don't see if it was resolved.
Can you help me.
- JotForm FounderaytekinAnswered on December 03, 2013 at 11:25 AM
I asked one of our developers to look into the issue and get back to you. We have re-implemented the google spreadsheets integration since then so the problem should be resolved.
- nicolasfranco0Answered on December 03, 2013 at 11:29 AM
Thanks for your answer. So I wait for your solution.
Thanks for your having been fast to answer
- alp_denizAnswered on December 04, 2013 at 12:49 AM
I had a look through and it seems that you had figured it out. The dates are registered with month/day/year but you can easily change that in google docs and continue to get submissions with your formatting choice.
Please let me know your case.
- nicolasfranco0Answered on December 04, 2013 at 04:17 AM
Thanks for your answer. Sorry i don't understand. I verified and my dates in Jotform and Google seem to be registered with day/month/year... Or i don't know where to verify it and change it.
Maybe that's why ;-)...
- EliezerNAnswered on December 04, 2013 at 08:49 AM
Thanks for the clarification.
You can change the date format from the Google docs. Please follow the instructions in the image to know how:
Inform us if you need more help.
- nicolasfranco0Answered on December 04, 2013 at 10:25 AM
Thanks. No it's the same...
However, three complementary things which maybe could help you :
- i have another date fields which work well (the date is filled by user), and no automatically like this one submission date
- when i make a new integration, the date is OK
- it seems to be the automatic implementation beaucause when i go through the excel generated in jotform site, in "my forms"/"reports", it works (notice than one more field doesn't appear on new submissions automatic, but appears when i generate a new integration)...
Google seems to be complicated ;-)...
- JotForm Support ManagerJeanetteAnswered on December 04, 2013 at 11:52 AM
Looks like the problem is isolated to one single form? I take this for granted as you say other integrations show the date OK.
if that is the case, can you please try to rebuild the integration?
At any rate, you are right, the google spreadsheet functionality is kind of challenging, sometimes
- nicolasfranco0Answered on December 04, 2013 at 12:01 PM
Thanks. no i made it several times and it's always the same. The real difference is that the correct date is filled by the user and the one which doesn't work is filled automatically by the system (it's the column "submission date")