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

    problem with dates copy over to google drive

    Asked by debs2105 on November 28, 2013 at 04:00 AM

    Hi I am still having a problem with my new for submissions copying over to google drive.

     

    As you can see it saves it in a different format so then will not sort the data into date range. I have contcated you a lot of times now with this problem and have tried everything that you have suggested but the only thing that works is to delete the connection and then re do it, it then puts the dates in correctly. why is it not doing it when a new submission is placed?

     

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

    problem Submissions format different
  • Profile Image
    JotForm Founder

    Answered by aytekin on November 28, 2013 at 06:50 AM

    We will look into the problem with dates on google spreadsheet integration and get back to you. 

    Thanks for your patience. 

  • Profile Image

    Answered by debs2105 on November 30, 2013 at 05:31 AM
    Hi I still do not seem to have recieved an update with regards to the
    problem with dates to google spreadsheet.
    please can you advise asap as i am using these documents for work and need
    to be able to sort by date range
    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 Founder

    Answered by aytekin on November 30, 2013 at 03:21 PM

    One of our engineers will look into the issue within a week or so. Can you use the Excel export for now? 

    http://www.jotform.com/help/101-How-to-create-an-Excel-Report

  • Profile Image
    JotForm Support

    Answered by alp_deniz on December 01, 2013 at 02:40 AM

    Hello Ms. Deborah,

    We have identified and fixed the problem : The dates were not converting to datetime format of google spreadsheets. You may now sort your data with the given dates, however you may also need to re-integrate the form.

    All the best

    Alp

  • Profile Image

    Answered by nicolasfranco0 on December 03, 2013 at 07:06 AM

    HI !

    I seem to have the same problem (sorry i post there too because this post is morer recent). The format of my sublission date is false (it stays mm/dd/yyy). My Preferences in the spreadshit and my accounts (google & jotform) are good (France and GMT+1 (Paris).

    Do you konw how can i solve it ?

    Thanks

  • Profile Image

    Answered by Cesar on December 03, 2013 at 01:39 PM

    @nicolasfranco0

    Kindly create a new thread so that we may be able to provide you further support. This is needed so that there is no confusion with what has been previously discussed, as we are working on one issue per thread. Thank you.