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

    Excel submissions date & time problem

    Asked by corporatevents on April 04, 2016 at 10:45 AM

    Hi we have launch a quiz toaday at 11:00 am and this quiz should ended at 24:00pm in Belgium, now at 15:26 pm whe have downloaded the excel files with the submissions it seems to have a problem with the timestamp used in the field Submission date, the first submissions begins at 

    2016-04-04 04:52:41

     wich is impossible we start the quiz at 11:00 am

    We are afraid that the quiz won't finish at 24:00pm or that people are going to discuss because of that problem.

    Can you help us ?

    Thanks in advance

    Gérard 

    Page URL:
    https://form.jotform.com/60625697949979

    Screenshot
    Submissions problem excel excel submissions
  • Profile Image
    JotForm Support

    Answered by Charlie on April 04, 2016 at 12:53 PM

    The submission date and time depends on the timezone of your account settings. I'm checking your account and the timezone is set in EST. 

     

    You need to set the timezone in Belgium to sync with your own time.

    You could also integrate your form to Google Spreadsheet to give you a real-time list of submissions online.

    Let us know if that helps.