Access and retrieve Submission Date

  • MXNS
    Asked on December 11, 2020 at 4:04 AM

    Can the Submission Date, what ends up in the Table in Jotform or Google Sheets, be added as a parameter? So I can populate one form with the submission date of another form. {SubmissionDate} or {SubDate} or something?

  • Vick_W Jotform Support
    Replied on December 11, 2020 at 5:00 AM

    Hi there,

    The submission data will always be the current date. You can add a "Date Picker" field in your form.

    1607678366 5fd3399e250e2  Screenshot 10

    Then enable the current date option in the date field.

    1607678487 5fd33a176965a  Screenshot 21

    Then you can add a text field to pass the date using a condition.

    1607680501 5fd341f5d737f  Screenshot 32

    Then you can add the following URL in the Thank You Page "Redirect option" to prepopulate in the targeted form.{submissionDate}

    1607680682 5fd342aa0e103  Screenshot 43

    Please make sure that the field IDs are exactly the same in both forms.

    You can test this in the demo form below.

    Here is how you can clone it.

    Let us know if you need further assistance.


  • MXNS
    Replied on December 11, 2020 at 9:11 AM

    So the answer is no. Got it.

  • Cecile JotForm Support
    Replied on December 11, 2020 at 9:39 AM

    Hello there,

    Have you tried my colleague's suggestion yet?

    If my colleague's suggestion did not meet your requirements, may I know the flow of activities you are trying to achieve? Perhaps we could provide you a workaround.

    Looking forward to your reply. Thank you.

  • MXNS
    Replied on December 16, 2020 at 1:49 PM

    I need an actual timestamp, not a field that just collects what time it is.

    The Default Time set to Current gives you the time that form was opened by the user, not the time it's submitted.

    If a user takes 30 minutes to fill out a form, the timestamp is now 30 minutes early. I've tried experimenting with hiding that field on a separate page at the end with just a submit button, so a user would fill out the whole form, go to the next page where the Current Time is now set and just submits. But it's still subject to user error and depending on how long it takes the user to push submit, it can get close to the actual timestamp, but not exactly.

    However, the biggest problem with this solution is that many of our forms use the Edit Submission link to run an approval process for the form submitted. So the form is resubmitted by an approver. When the approver opens the form to resubmit it, the Current Time is reset. I've tried setting the Current Time/Date field to disable itself to avoid the timestamp from resetting, but it doesn't work.

    The "Submission Date" which is on the form's table and is populated in Google Sheets is unchanged by a resubmission. That's the field I'm trying to access and pass along.

  • Cecile JotForm Support
    Replied on December 16, 2020 at 4:07 PM

    Thank you for your response.

    After some tests and attempts for a workaround, the suggestion provided by my colleague above is the only workaround close to what you require since it is not currently possible to send submission date and time information.

    I have created a feature request ticket and will be forwarding it to our backend team for possible implementation. 

    Please note that we can't give an ETA for when this will be implemented. Feature requests depend on the workloads of our developers and popularity among our users. But rest assured that we will inform you via this thread once this feature becomes available.

    Let us know if you need further assistance.

  • dougsacarto
    Replied on December 27, 2020 at 2:38 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.



  • KrisLei Jotform Support
    Replied on December 27, 2020 at 5:16 PM

    Hello Doug,

    I have moved your query on a different ticket to address it accordingly. I will get back to you shortly through this link:

    Thank you.