JotForm as Event Ticket Check-In

  • atrsports
    Asked on August 18, 2018 at 9:24 PM

    I noticed the QR code reader and scanner and was wondering if JotForm could be used as a check-in solution for events.

    Here's what I would need it to do:

    1. Scan a QR code
    2. Check the scanned information against a registration list
    3. Bring up basic information on the ticket holder
    4. Somehow mark that ticket as "used" so people can't use a duplicate

    I don't think this is possible, but I have seen some pretty cool stuff with JotForm, so before I spend a lot of money on an outside solution I thought I would check.

  • DonaldHag
    Replied on August 19, 2018 at 12:43 AM

    Using the information above, I have created a demo Form here https://form.jotform.com/82299618172971 that generates a QR Code and sends it to the ticket buyers email. In addition, I have added a report that lets you view all the Submissions here https://www.jotform.com/table/82300943972054/ the password is 123456789. You can clone this form as a starting point.

    Here is how it is implemented;

    1. Scan a QR code

    Here use the Dynamic QR Code Widget which allows the use of a Form Field to generate the QR Code. In this case, I used the Summary Long Text Field. Then I used conditional logic to populate the field with data from other fields of the form. In addition, I set the field as read-only so the user cannot change it.

    3. Bring up basic information on the ticket holder

    On scanning the code, it will bring up basic information about the ticket owner. i.e. the Name, Email and Ticket Type

    2. Check the scanned information against a registration list

    You can create a report to show the information in a list. I added a Grid List Report: https://www.jotform.com/table/82300943972054/ with password 123456789 to show the registration list on a link online.

    4. Somehow mark that ticket as "used" so people can't use a duplicate

    For this, I added a hidden field on the form that can be edited in by the form owner to show the status of a ticket as "used" or "unused".

    This is just a starter template and you can add multiple items to the form including images, payment widgets to purchase tickets online and fields to collect more data on the user.

    For further assistance on this, do let us know.



  • atrsports
    Replied on August 19, 2018 at 1:03 AM

    Great solutions, thank you very much. I'll try that.

    If all goes well, though, the sign-in process will be hectic. I'm not sure staff will have time to manually mark the registration page as "used" or manually check the registration list. I don't suppose there is a way to automate those two items?

  • John_Benson
    Replied on August 19, 2018 at 6:42 AM

    You can enable the Unique Question feature to stop duplicate submission. For more information, please check this link: https://www.jotform.com/help/223-How-to-set-Form-Limits-Based-on-a-Unique-Question

    Give it a try and let us know if you have any questions.