How to retrieve the submission data based on unique ID?

  • Profile Image
    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

  • Profile Image
    ashwin_d
    Answered on June 19, 2017 at 11:13 PM

    Hello psmgpy,

    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!

  • Profile Image
    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,

  • Profile Image
    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. 

    Please refer to the guides below for more information:

    How-to-Perform-Form-Calculation-Using-a-Widget

    Smart-Forms-Using-Conditional-Logic

  • Profile Image
    psmgpy
    Answered on June 20, 2017 at 07:37 PM

    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.

  • Profile Image
    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.

    If you mean something else, please let us know.
    Regards.