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.
Google Integration: Change Format on Submissions DateAsked by steelneil81 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?
Hi steelneil81, can you please provide us with the form URL to further assist you. Thanks!
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
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
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
But surely the issue is with JotForm as this is the source of the information.
JotForms servers are in the US format. We cant really change those date format settings on a per user basis.
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!
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.
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]
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
really pleased Mrs. Jeanette
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.
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
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.
though its taking quite long i am assured you guys can handle it.
... cause jotform is THE BEST! ;))
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.
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.
Thanks for your answer. So I wait for your solution.
Thanks for your having been fast to answer
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.
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 ;-)...
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.
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 Manager
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
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")