Submission Timestamps in Milliseconds

  • Profile Image
    dougsacarto
    Asked on December 27, 2020 at 05:15 PM

    Jotform Support:

    I have a similar interest in having a true timestamp (so time is in milliseconds) that is saved when the record is inserted and then not altered by subsequent updates. With email setup, the system function {date} provides that, I think. But that element is not interpreted as best I can see in form field defaults. That would perhaps be a solution.

    Another might be to have option for the "current date" to be the full timestamp in milliseconds. My needs, however, are not affected by user delays in filling out the form. Just need it saved on submission.

    Thanks,

    Doug

  • Profile Image
    KrisLei
    Answered on December 27, 2020 at 05:30 PM

    Hello Doug,

    Kindly try to check the Time Tracker widget, that you can add on your form, it seems that it shows the time in milliseconds on the Tables:

    1609108033_5fe90a418b7ca_Screenshot_1228

    For reference: How-to-add-a-widget-to-your-form

    Here's a demo form, wherein you can clone it on your account: https://form.jotform.com/203616539634964

    Guide: How-to-clone-an-existing-form-from-a-url

    Please note that the widget is not visible on the form builder and it is hidden by default but the results is shown on the tables.

    Then let us know if it didn't meet your requirements. Thank you.

  • Profile Image
    dougsacarto
    Answered on December 27, 2020 at 06:05 PM

    Sorry, I think the question I posted was not clear. I do not need to record how long the respondent took to complete the form submission, which is what I think "time tracker" widget provides.

    I am interested in what the other user was asking for: that a timestamp be saved to the responses table when the form is submitted, and that timestamp is not altered if the response is edited later. I believe the problem raised by the other user is that the date saved is not precise enough. Needs to be exact to milliseconds, not just minutes or seconds.


  • Profile Image
    Ariel_P
    Answered on December 27, 2020 at 07:55 PM

    Hi there,

    Thank you for your message.

    Unfortunately, timestamps currently support for up to seconds precision only.

    Let me forward this to our backend team as feature request. We will notify you if it gets implemented.

    Should you have any further inquiries, we will be more than happy to help.