Access and retrieve Submission Date

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?

Hi there,

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

Then enable the current date option in the date field.

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

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}

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

So the answer is no. Got it.

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.

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.

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.

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.