Give submission a unique ID and find them again via QR code

  • Cogetil
    Asked on June 10, 2015 at 4:07 AM

    Hi

    have read this post from another user http://www.jotform.com/answers/16156-Unique-ID-submission-transformation-in-Barcode#5

    my question is, can you give your submissions a unique nr, and generate a QR code/barcode, then look up the submission by scanning the barcode ?

  • Boris
    Replied on June 10, 2015 at 6:00 AM

    Hello.

    This is a very interesting concept. You can use {id} to get the Submission ID number, so the link can be changed to:

    http://www.barcodesinc.com/generator/image.php?style=197&type=C128B&width=330&height=80&xres=2&font=4&code={id}

    I have tested this on my end, and this is what I received in my Email Notification:

    Give submission a unique ID and find them again via QR code Image 1 Screenshot 20

    I believe that this is what you are looking for, and the bar code number will be the Submission ID number, which you can view on your View Submissions page, or in your exported Excel files, etc.

    Please let us know if you need further assistance.

  • Cogetil
    Replied on June 10, 2015 at 6:06 AM

    hi 

    yes, that was what i want, but is it not possible when you scan the barcode or qr code, it go in and look up the submission automatically 

  • Boris
    Replied on June 10, 2015 at 9:29 AM

    We do not allow any lookup based on only your submission ID, or only your form ID, due to security reasons. For that reason, to achieve the task that you are wanting - confirming by a barcode that a submission has been received - i can recommend only the following solutions at this time.

    1a. You could try setting your barcode scanning software to check for that number in the exported Excel format of submissions.

    1b. You can also set up an excel report, so that you can quickly download this Excel file with all the latest submissions included regularly, and use your barcode software to check this report for the ID.

    1c. Or if you can scan Google Spreadsheet documents, you can also integrate your form with Google Spreadhseet, and have your submission data automatically forwarded there after every submit. Then you would be scanning this data in Google Spreadsheet.

    2. You can store your data to your own database, and then check your own database with your barcode software:

    How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP

    Please let us know if we can assist you further.