Access and retrieve Submission Date

  • Profile Image
    MXNS
    Asked on December 11, 2020 at 04: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?



    This is a re-post of a comment on Prepopulating Fields to Your JotForm via URL Parameters

  • Profile Image
    Vick_W
    Answered on December 11, 2020 at 05: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_

    Then enable the current date option in the date field.

    1607678487_5fd33a176965a_

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

    1607680501_5fd341f5d737f_

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

    https://form.jotform.com/203451599543057?submissionDate={submissionDate}

    1607680682_5fd342aa0e103_

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

    You can test this in the demo form below.

    https://form.jotform.com/203451698277061

    Here is how you can clone it.

    https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL

    Let us know if you need further assistance.

    Thanks

  • Profile Image
    MXNS
    Answered on December 11, 2020 at 09:11 AM

    So the answer is no. Got it.

  • Profile Image
    Cecile_A
    Answered on December 11, 2020 at 09: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.


  • Profile Image
    MXNS
    Answered on December 16, 2020 at 01: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.

  • Profile Image
    Cecile_A
    Answered on December 16, 2020 at 04: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.

  • Profile Image
    dougsacarto
    Answered on December 27, 2020 at 02: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.

    Thanks,

    Doug

  • Profile Image
    KrisLei
    Answered on December 27, 2020 at 05: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: https://www.jotform.com/answers/2787231

    Thank you.