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

    Date Format in Google Spreadsheets

    Asked by leehead on December 06, 2012 at 05:18 AM

    I've linked my Jotform repsonses with a Google Spreadsheet and it all works great. However, I have a date field in my form and when the data gets sent to google it shows up in a hyphenated format (eg 6-12-2012). Google calendar doesn't recognise this as a date and therefore I cannot sort in chronological order. Is there any way to reformat the date into forward slash format (either via jotform or google spreadsheets) eg. 6/12/2012 so that it's recognised as being a date by the spreadsheet?

    format JotForm date field Google Calendar
  • Profile Image
    JotForm Support

    Answered by abajan on December 06, 2012 at 07:20 AM

    Currently, there's no way in the form builder to reformat dates in the manner described. However, as a workaround, it is possible to use a script to both copy the values of the date field's inputs to a (preferably hidden) text box and convert the date to the Google Calendar format. However, since this solution would use a script, it would require embedding a copy of the form's full source into a web page and adding the script to the said page.

    I can clone your form, apply the aforementioned solution and get back to you with the requisite script, if you're okay with going the full source route. Please let me know your thoughts on that.

    In the meantime, I'll submit a ticket requesting that dates in submission records either contain slashes instead of hyphens or (better) that a date format switching tool be made available in the submission records page.

    I'll await your decision on using the form's full source.

    Thanks.


    P.S. If Google Calendar recognises dates in the plain English format like
    January 1, 2013, the Birth Date Picker tool can be substituted for the DateTime one.

  • Profile Image

    Answered by leehead on December 06, 2012 at 08:54 AM

    Hi abajan,

    Thanks for the informative reply. It turns out that Google Spreadsheets does work with the Birth Date Picker format and it works as required so I'm quite happy using that until the regular date picker issue is resolved - saves us both some work. Cheers for your help!

     

    --Lee

  • Profile Image
    JotForm Support

    Answered by abajan on December 06, 2012 at 09:49 AM

    That's great news, Lee!

    Cheers :)


    Wayne

  • Profile Image

    Answered by markashton on July 31, 2013 at 06:47 AM

    Has this been fixed then?

    Because I see that the jotform's integration with Google Spreadsheets does not bring the date of submission in properly .. it is not seen as a date.

    So, everyone using your google speadsheet integration has no submission date sort capability

    Lame!

    Can this be fixed please

    Thanks Mark

  • Profile Image

    Answered by jefreylandicho on July 31, 2013 at 07:32 AM

    I believe this issue has been resolved already as you can see in the video below, I can sort the submission date without any problem.

    http://screencast.com/t/9ZXZxneC