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

    Editable DateTime with current time as default field does not match the date and time of submission

    Asked by tplink_ar on July 07, 2015 at 05:13 PM

    We have a custom form, used to open and close support tickets. But we see in the reports (like Excel or Jotforms Analytics) that don´t match the real time or with the Submission Date in the reports, or closing time in the form. We were observing, the time when starting the form and when is closing, and the mostly cases is mismatch. Could be a bug or maybe we have some wrong done in the form ?

    for example :

    Submission Date Ticket  Closing case
    2015-07-07 15:42:30  2447 07-07-2015 16:19:22
    2015-07-07 15:41:25 2446 07-07-2015 16:25:56
    2015-07-07 15:19:18 2445 07-07-2015 14:05:05
    2015-07-07 15:13:34 2444 07-07-2015 16:24:51

     

    Underlined when mismatched

     

    Thanks for your help.

    Screenshot
    Reports closing DateTime Submission date
  • Profile Image

    Answered by Ben on July 07, 2015 at 06:23 PM

    I took a look at your jotform and from what I can see the "Cierre del caso" DateTime field is the only one to capture the date and time, but it is set to allow the time and date to be changed by the user filling out the form.

    This means that they could set it up to show any time they wish.

    Also, please do note that this will also load with the current time of the person opening the form, while the submission date is based on the time of our server, so it might be different depending on where the people submitting the form are based in.

  • Profile Image

    Answered by tplink_ar on July 08, 2015 at 09:40 AM

    Thanks for your answer. Is possible can tuning the submission date according the based in the country, for example? or is automatic from the  server ? thanks

  • Profile Image

    Answered by Ben on July 08, 2015 at 11:22 AM

    The submission Date is default to the server location, but you can set your time zone in your account, which should impact what time is shown as the time of submission.

    You can do that by going to your Account -> Settings -> Timezone

    Do let us know if that helps and if you have any issues setting it all up and we would be happy to assist.