How can setup my "submission date" to reflect the time my form was submitted?

  • deliverygurullc
    Asked on July 20, 2015 at 3:58 AM

    That is of course, as opposed to went the form was started or opened. I basically need to start the clock on the receiving end based the finger leaving the submit button. Any help but I'm really hoping for an easy fix. Thanks for any!

  • Chriistian Jotform Support
    Replied on July 20, 2015 at 5:34 AM

    Hi deliverygurullc,

    Thanks for contacting us.

     

    Are you referring to the Submission Date shown in the submission data of your form? See screenshot below.

    How can setup my submission date to reflect the time my form was submitted? Image 1 Screenshot 20

     

    As per checking, the value for the Submission Date is the time when your form is submitted. If you are referring to a different Submission Date, can you give us more information so we can further analyze the issue?

     

    We will wait for your response.

    Regards.

  • deliverygurullc
    Replied on July 20, 2015 at 5:50 AM

    Yes that is the submission date I am referring to. I even have the time field on the form in question but current time seems to be the only default value. I have tested this out for myself and unless there is a 10 to 15 minute delay on a form submission being received at times, which I have deduced not. I'm left to believe that the count begins when the form is opened. Seemed that way with Google forms too before I made the switch. Is that not the case?

  • deliverygurullc
    Replied on July 20, 2015 at 5:55 AM

    The time is generated on form open and we run a tight schedule. When a customer opens the form because they want to order and then for whatever various reasons doesn't actually hit that submit button until 15 minutes later is crucially misgiving.

  • Chriistian Jotform Support
    Replied on July 20, 2015 at 8:36 AM

    Hi deliverygurullc,

     

    The Submission Date in my post above is the value of time generated based on when the user submits the form (not when the user opens the form). Please note though that the submission dates that you will see will depend on the timezone you have set on your profile. To make sure that you have the correct timezone settings on your profile, please see screenshot below.

    How can setup my submission date to reflect the time my form was submitted? Image 1 Screenshot 20

     

    May I ask the name/link of the form you are working on so we can test and check it?

     

    Regards.

  • deliverygurullc
    Replied on September 25, 2015 at 1:19 AM

    I have a field that is just time. I have the field set to populate the current time as the default for this hidden field. The problem I am experiencing is that the time generated is based on when the form is first started. For example, if a customer opens the form at 9:35 am but does not submit the form until 11:00 am, which is the case and can be seen here http://form.jotformpro.com/form/52272047015951, Sub ID#318574006032455766, then it looks like we are behind schedule for nearly an hour and a half.

    My question is-Is there a way to have this time match the time generated with the submission date?

  • Chriistian Jotform Support
    Replied on September 25, 2015 at 2:52 AM

    I see what you are referring to. The hidden date and time field value is based upon load of the form. Unfortunately, we do not have a feature that can make the field update to the same value of the submission date since the submission date is being captured once the submission data has been posted in the database.

     

     

  • deliverygurullc
    Replied on September 25, 2015 at 10:15 AM

    Ok, it is what it is.

    Thanks Chriistian

  • Ben
    Replied on September 25, 2015 at 12:08 PM

    In my colleague's name, you are welcome.

    Now I do wish to add to this by saying that there is indeed not a way to do this through the Form Builder, but there is a way to do this in 2 different ways:

    1. by grabbing the forms full source code and getting the details you are after through the custom modification of the same.

    2. By adding additional widget to your form which would not change the data and time, but will give you extra details about the time of submission.

    Now we can not assist you much with the first option, but with the second we can. What I mean by it is to add the DateTime field to your form and set them both to current time. Once that is done, to also add additional widget such as Time Tracker widget.

    This is how I set the email to be sent to me:

    How can setup my submission date to reflect the time my form was submitted? Image 1 Screenshot 20

    As you can see, while it is in 2 different fields, it gives me the exact time that it took the user to fill out the form no matter if it was few seconds, minutes or even an hour or two, which does not take a long time to add (manually) to the time above.

    Hope that this helps.

  • deliverygurullc
    Replied on September 25, 2015 at 4:24 PM

    Thanks Ben!

    Simple enough. I am collecting changes to be made that aren't "high priority" but "get to it eventually priority" and this one definitely goes in that stack to be done all at once with the rest after a trial on a test form. All about the formulas doing that math and I don't want to upset the current apple cart. Thanks again sir!

  • Ben
    Replied on September 25, 2015 at 4:33 PM

    You are welcome :)

    I am glad that it is something that might help :)

    Do let us know of course if you happen to have any other questions that we might be able to assist with and we would be happy to do so :)

  • deliverygurullc
    Replied on September 25, 2015 at 4:34 PM

    Yes sir, you know I will :)