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

    Incorrect Date Format in Google Spreadsheet Integration Document

    Asked by debs2105 on November 19, 2013 at 07:12 AM

    Hi 

    My dates are not alwasy copying over to google drive in the correct format

     

    https://docs.google.com/spreadsheet/ccc?key=0Ah7bCzYU_AbzdHl5MUoyM00zUW9rZzZ0dHJVOTYtVEE&usp=drive_web#gid=0

     

    I have dleteated the association and re done it and then it rights itself but the the next time somebody adds a booking it has the same problem. I dont want to have to re associate this form every time as you can see i have hidden quite a few columns and added info in so dont want to re do this.

     

    please can you advise urgently please

    Page URL:
    https://docs.google.com/spreadsheet/ccc?key=0Ah7bCzYU_AbzdHl5MUoyM00zU<br/>W9rZzZ0dHJVOTYtVEE&amp;usp=drive_web#gid=0

    problem hidden format next
  • Profile Image
    JotForm Support

    Answered by guilledutra on November 19, 2013 at 10:11 AM

    Hi,

    please give us permissions  to check your google drive files, I already requested permissions using my personal email guiman.uy@gmail.com, after making some test with a cloned version of your form, google drive pdf files are ok, the dates fields appears to be ok from my side,could you describe better the dates issue in order to make further investigations.

     

    Thanks

  • Profile Image

    Answered by debs2105 on November 19, 2013 at 10:21 AM
    https://docs.google.com/spreadsheet/ccc?key=0Ah7bCzYU_AbzdHl5MUoyM00zUW9rZzZ0dHJVOTYtVEE&usp=drive_web#gid=0
    permsiion granted with this link
    as you can see some of the dates are sorting 12/01/2013
    and some 12-01-2013
    this makes it impossible to sort by date in a column.
    this has happened before and if i cancel the intergration and start again
    it rights it self but then happens the next time
    i am having to either keep re doing it or manually typing the dates in
    Kind Regards
    Deborah Smith
    *www.delaterre.eu.com *
    T: 0033 (0)627963657
    *De La Terre provide Catering services and meal deliveries to
    ski chalets and apartments in Samoens and Morillon. *
    De La Terre customers will receive a discounted price when booking their
    transfers with MST . Please quote MST100
  • Profile Image
    JotForm Support

    Answered by guilledutra on November 19, 2013 at 10:40 AM

    Hi,

    my mistake, I think you were talking about the Google Drive integration but I can see the described issue using the GSpreadsheet Integration, after making some tests I think the best workaround in order to fix this  is by setting to "Plain Text" the format of the spreadsheet columns containing the dates records, please follow the next steps:

    1. Enter to the GSpreadsheet file

    2. Select the dates columns

    3. Click on "Format" icon from the toolbar and the "Number" sub-menu

    4. Select "Plain Text"

    From now on new submitted data will maintain the correct date format.

    Hope it helps

    please let us know if you need further assistance

    Thanks

  • Profile Image

    Answered by debs2105 on November 19, 2013 at 01:43 PM
    Hi
    I have done this i have un intergrated the liason and re done it and it
    works, as soon as i have just entered new data it has done it exactly the
    same and collected the data with a / not a - and then google will not read
    it in date form.
    This is really irritating me know as I dont have the time to keep dealing
    with this. please can you advise me as to what the problem is and how it
    can be rectified.
    thank you for your help
    Kind Regards
    Deborah Smith
    *www.delaterre.eu.com *
    T: 0033 (0)627963657
    *De La Terre provide Catering services and meal deliveries to
    ski chalets and apartments in Samoens and Morillon. *
    De La Terre customers will receive a discounted price when booking their
    transfers with MST . Please quote MST100
  • Profile Image
    JotForm Support

    Answered by Welvin on November 19, 2013 at 04:00 PM

    Hi,

    Our since apology for this matter. We will surely do our best to help you resolve the date formatting. Please try changing your date format from the spreadsheet settings, please refer to this guide: https://support.google.com/drive/answer/58515?hl=en. This settings work form so this should work for you as well.

    Screenshot:

    Form: http://www.jotformpro.com/form/33057491855966

    Spreadsheet: https://docs.google.com/spreadsheet/ccc?key=0AgEiJQf5QINCdHBQbVlGakx5aUJ0RHl6YUhLYkVsa0E#gid=0

     

    Test the form for you to see the output to the spreadsheet.

    Thanks