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 Google Sheets, dd/mm format go to mm/dd

    Asked by leo8nardo8 on December 28, 2015 at 07:39 AM

    I'm having this problem

    This is in the JotForm Answer

    And in the Google Sheets, this date come like this

     

     

    In my form, the date format is set DD/MM/YYYY, and all the submissions are OK, but in the Sheet i'm having this format problem.

     

    How can I solve this?

  • Profile Image

    Answered by victor on December 28, 2015 at 09:34 AM

    Sorry for this inconvenience. I have just cloned your form and was not able to recreate your issue. Could you please try to re-integrate your spreadsheet and see if this resolves the issue.

    If you still experience this issue, please let us know and we will be glad to take another look.

  • Profile Image

    Answered by leo8nardo8 on December 29, 2015 at 05:38 AM

    I try to re-integrate my spreadsheet and I didn't have the same issue.

    Thank you.

  • Profile Image
    JotForm Support

    Answered by Charlie on December 29, 2015 at 10:29 AM

    Glad to hear that re-integrating resolves your problem. Should you need any assistance again, feel free to contact us here in the forum.

    Thank you.

  • Profile Image

    Answered by leo8nardo8 on December 30, 2015 at 02:39 PM

    I have already re-integrate 3 times my sheet.

    Every time I re-integrate the problem is solve, but when I get new submissions this erros repeat.

    Look at the last answer, they come with a diferent format, and this cause me problens in others sheets.

     

    What should I do?

  • Profile Image
    JotForm Support

    Answered by david on December 30, 2015 at 06:06 PM

    It could be that the format of the spreadsheet is not the correctformat  and it needs to be changed, or you can change the format of your date fields to mmddyyyy.

    This should change the fields automatically to the proper format.

  • Profile Image

    Answered by leo8nardo8 on December 30, 2015 at 06:52 PM

    Thanks, it works!!

     

    :D

  • Profile Image
    JotForm Support

    Answered by Mike_G on December 30, 2015 at 10:33 PM

    On behalf of my colleagues who helped you with your concern, you're most welcome! Feel free to contact us anytime if you have any other questions or concerns. Thank you.

  • Profile Image

    Answered by leo8nardo8 on January 13, 2016 at 06:25 AM

    Guys everytime I get new submissions I'm geting problems.

    They with 3 diferente format, and I cannot correct.

    Before the integrate they come with the format dd-mm-aaaa hh:mm:ss

    After integrate 5 submissions come with MM/DD/aaaa hh:mm:ss

    And the last 3 come tiwh DD/MM/AAAA hh:mm:ss

     

    Same thing in another column

    Before integrate dd/mm/aaaa

    After integrate 4 with dd/mm/aaaa

    3 with mm/dd/aaaa

    1 with dd/mm/aaaa

     

    Help pls :)

  • Profile Image

    Answered by victor on January 13, 2016 at 09:01 AM

    Sorry for this inconvenience. I have retest the integration and was not able to replicate the issue. Could you please indicate if this occurs randomly, at certain times, and with the format already set.

    I will submit forms for a couple of hours and see if I can replicate the issue. If I'm able to replicate the issue, I will keep you informed.

  • Profile Image

    Answered by leo8nardo8 on January 13, 2016 at 09:06 AM

    When I re-integrate the form all the "past" date come with the same format. But after the re-integrate when I get new submissions the format os dates changes.

    It seems to be randomly. I tried to set the format to the cells, but didn't work to me.

    Thanks for the help.

     

  • Profile Image

    Answered by victor on January 13, 2016 at 10:59 AM

    Thank you for the update. Like I mentioned, I will be tested on the course of the day. At the moment I have submitted forms but was not able to replicate the issue you are having.

    I have played with the format in the spreadsheet, but it does not change when I submit the form. If I find anything, I will let you know.

  • Profile Image

    Answered by leo8nardo8 on January 14, 2016 at 12:08 PM

    Any news?

  • Profile Image

    Answered by victor on January 14, 2016 at 01:23 PM

    Sorry for not getting back you sooner. I have been testing the spreadsheet integration. At the moment I was not able to replicate the issue you are having. I have modified the format many times as well as remove and integrated the spreadsheet.

    The dates are always entered in the same format.