What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

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.


  • Profile Image

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

    Asked by Cogetil on June 10, 2015 at 04: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 ?

  • Profile Image

    Answered by Boris on June 10, 2015 at 06: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:

    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.

  • Profile Image

    Answered by Cogetil on June 10, 2015 at 06: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 

  • Profile Image

    Answered by Boris on June 10, 2015 at 09: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.