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 Spreadsheet: Incorrect Date Format

    Asked by debs2105 on November 09, 2013 at 11:32 AM

    Hi I have now set the data up to automtically go to google drive which is fantastic but..... some of the date entries are showing as the following format 9/12/2014 and some as 09-12-2014 so it will not sort the info properly please advise as to why?

    format
  • Profile Image

    Answered by khrisell on November 09, 2013 at 08:42 PM

    Hello,

    Can you share us the google spreadsheet link or simply a screenshot of it so that we could check the error you are currently having.

    Thank you and we will wait for your response to assist you further on this.

  • Profile Image

    Answered by debs2105 on November 10, 2013 at 07:22 AM
    hi khrisell
    here is the url for the sheet, as you can see for some reason the arrival
    date and departure dates are showing in different formats through the
    column which make sit impossible for me to sort by date range:
    https://docs.google.com/spreadsheet/ccc?key=0Ah7bCzYU_AbzdGYxdHNOUDJQODhVUXZ6Zm5TdGxHcWc&usp=sharing
    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 jonathan on November 10, 2013 at 08:43 AM

    Hi Deborah,

    I was able to see this inconsistent behavior of the data in your form's integrated spreadsheet.

    But I would like to gather more details before we can elevate the issue to our next level support.

    I am assuming that this is the form involve http://www.jotform.com/32644484996369 

    May I inquire if the form is embedded on a website? Please share to us the URL of the website where we can test the form used.

    If not embedded on the website, can you confirm that you only uses the form using its direct URL http://www.jotform.com/32644484996369 ?

     

    We will await for your updates.

    Thanks.

  • Profile Image

    Answered by debs2105 on November 10, 2013 at 09:59 AM
    hi
    it is embedded on a website here as well the link is this: Our chalet
    owners booking form via our
    website
    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 10, 2013 at 11:56 AM

    Can you please re-paste the webpage URL? We can't see it from your last reply. Also, did you try re-integrating the form to Google Spreadsheet? Can you try that? See if that will resolve the issue.

    Thank you.

  • Profile Image

    Answered by debs2105 on November 10, 2013 at 12:28 PM
    hi I have re intergrated the form in google spreadsheet and it seems to be
    fine now. thank you
    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 10, 2013 at 12:38 PM

    Great! Please be sure to let us know for any issues with your forms. We are here to help.

    Thanks