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

    Google Integration: Change Format on Submissions Date

    Asked 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?

    date and time JotForm format Google Site
  • Profile Image
    JotForm Support

    Answered by EduardoMendez on August 29, 2012 at 10:03 AM

    Hi steelneil81,  can you please provide us with the form URL to further assist you.  Thanks!

  • Profile Image
    JotForm Support

    Answered by NeilVicente on August 29, 2012 at 12:58 PM

    @steelneil81

    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

  • Profile Image

    Answered by steelneil81 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

  • Profile Image

    Answered by jeanettebmz 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

    google spreadsheet settings

    If you are still unable to change the date to UK format , you should contact Google docs support

  • Profile Image

    Answered by steelneil81 on September 06, 2012 at 09:05 AM

    But surely the issue is with JotForm as this is the source of the information.

  • Profile Image
    JotForm Support

    Answered by fxr 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. 

  • Profile Image

    Answered by stevenyilin 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!

  • Profile Image
    JotForm Support

    Answered by Rodjit on October 07, 2012 at 03:44 PM

    @stevenyilin,

    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.

    Thanks

  • Profile Image

    Answered by richiesta_ferie 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]

    :-D

  • Profile Image

    Answered by jeanettebmz 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

  • Profile Image

    Answered by richiesta_ferie on October 22, 2012 at 11:36 PM

    really pleased Mrs. Jeanette

  • Profile Image

    Answered by richiesta_ferie 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.

  • Profile Image

    Answered by guest_30052210569040 on January 07, 2013 at 03:08 AM
  • Profile Image

    Answered by guest_30052210569040 on January 07, 2013 at 03:12 AM

    Hi,

    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

  • Profile Image
    JotForm Support

    Answered by idarktech on January 07, 2013 at 06:41 AM

    @guest_30052210569040

    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.

    Thanks!

  • Profile Image

    Answered by stevenyilin 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! ;))

  • Profile Image

    Answered by nicolasfranco0 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.

    Thanks

  • Profile Image
    JotForm Founder

    Answered by aytekin 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. 

  • Profile Image

    Answered by nicolasfranco0 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

    Best regards

  • Profile Image
    JotForm Support

    Answered by alp_deniz 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. 

    Regards

  • Profile Image

    Answered by nicolasfranco0 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 ;-)...

  • Profile Image

    Answered by EliezerN 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.

    Thanks

  • Profile Image

    Answered by nicolasfranco0 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 ;-)...

     

    Thanks

  • Profile Image
    JotForm Support Manager

    Answered by Jeanette 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

  • Profile Image

    Answered by nicolasfranco0 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")

  • Profile Image

    Answered by csemasthan on January 25, 2016 at 02:54 PM

    Hello, in my google docs respones saved in Untitled Folder, but i don't like this, i want save my fom responses with form id.. can u help me?