How to retrieve the submission data based on unique ID?

What is JotForm?

JotForm is a freeonline form builder which helps you create online forms without writing a single line of code.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.

Why do you not want to answer this thread?(Your answer will be sent to Jeanette and Aytekin)

psmgpy

Asked on June 19, 2017 at 06:56 PM

I am trying to create a form that automatically creates a date and timestamp that can be saved and printed for the customer. When the customer is ready to leave I need to be able to retrieve the ticket issued with a unique ID, so that I can enter it and calculate parking fees based on the original information. I have already created the forms but having an issue retrieving the unique ID and calculating fees. Thanks

I am not sure if I have understood your question correctly. Do you mean to say that when the retrieve the ticket details based on the unique ID / Random value which is generated when the form is submitted to create parking ticket?

Unfortunately it is currently not possible to fetch the data based on unique ID pr previous submissions or from any external source. To edit a specific submission record, you will need submission id. Please take a look at the following option and see if that fits into your requirement:

#1. You can go to your form's submission page and then search for records based on "Unique Id / Random value".

#2. You can edit the submissions and then calculate the parking charge. Please check the screenshot below on how to search for submission data:

Hope this helps.

Do get back to us if you have any questions.

Thank you!

psmgpy

Answered on June 20, 2017 at 11:32 AM

I think I figured out a work around, basically when my employee issues a ticket it will have the unique ID, date and time fields already populated. When the customer returns the employee can enter the unique ID, date and time manually from the ticket issued.

However, I need assistance on how to calculate a parking fee based on 30 minutes using the date and time fields.

Thank you,

Sven

Answered on June 20, 2017 at 12:47 PM

Can you please tell us the scenario and we will help you with the calculations? What are the fields you'd like to calculate. You can achieve that using form calculation widget, and depending on your scenario you might need to use conditional logic.

The scenario is that we charge for parking based on increments of time.

For example, you enter the parking lot, my employee chooses a location and selects "issue a ticket" the employee does not have to enter anything on this form except press "submit" and "print ticket". The printed ticket contains the unique ID and date and time stamp, which can't be edited.

When the customer is ready to leave, he/she hands my employee the printed ticket they received and my employee only enters the unique ID and date/time of entry from the original ticket issued. The date/time at exit is non-editable.

What I was hoping for is that when the employee is ready to process a ticket they select location and "process ticket" and they would only need to enter the unique ID upon and the entry date/time would automatically populate and calculate the amount due from the customer.

Thank you.

JotForm Support

Chriistian

Answered on June 20, 2017 at 10:59 PM

Unfortunately, there is no way to check the previously submitted data to compare it to the entered data on the form unless checking it manually on the Submission Page.

However, since your previous question was on how to calculate a parking fee based on 30 minutes using the date and time fields, could you please give us more details about it? If you mean you would only want to place 30mins on the minute's selections, you can do it by setting up the Minute Stepping.