Clarifications about QR codes and database in JotForm

  • Profile Image
    BigUnimelb
    Asked on October 21, 2017 at 04:13 AM

    Hey there, I am writing you this message for clarifications.


    1) Is it possible for jotform to cross-check an existing member database in either scenarios:

    a) Send into a google spreadsheet (members/ non-members) after automatically checked on the person who sign up.

    b) Provide different field form based on the name  or student ID typed in the form itself.


    2) Generate a QR Code in jotform at thank you page and email, such that the next time they are attending an event, all is needed is to use a QR code scanner to scan the code (only scan-able once), then it will automatically create new responses in a new google spreadsheet for attendees.

    3) If 2) is possible, it is also possible for the QR scanner to detect whether is someone a member/non-member.


    Thank you.

  • Profile Image
    Nik_C
    Answered on October 21, 2017 at 05:35 AM

    1) Is it possible for jotform to cross-check an existing member database in either scenarios:

    Unfortunately, we don't have such feature built-in, but you could use our Source code as the basic structure: https://www.jotform.com/help/104-How-to-get-the-Full-Source-Code-of-your-Form and then modify the form source code and add your custom scripts that would perform the database checking.

    This guide might help: https://stackoverflow.com/questions/44779921/php-check-if-row-exists-in-mysql

    2) Generate a QR Code in jotform at thank you page and email, such that the next time they are attending an event, all is needed is to use a QR code scanner to scan the code (only scan-able once), then it will automatically create new responses in a new Google spreadsheet for attendees.

    It is possible to generate a QR code in our forms, but not exactly in that manner. Here are our QR code widgets that we have: https://widgets.jotform.com/search/qr%20code

    What I meant, it is not possible to scan QR code that will make a new entry in Spreadsheet, I'm not sure how that is possible without user's action. 

    I don't see how that would be possible, the direction I'm thinking about, is to create a QR code of the prepopulate URL where the user will need to submit the pre-filled form, but I didn't find a way to create a QR code of the prepopulate URL from the current form. 

    So a workaround, without QR code would be to create prepopulate URL of the current data of the form where the user will need to click the link and submit the same data again if that is what you had in mind.

    Related guide: https://www.jotform.com/help/71-Prepopulating-fields-to-your-JotForm-via-URL-parameters

    Please let us know if that could work for you.

    3) If 2) is possible, it is also possible for the QR scanner to detect whether is someone a member/non-member.

    No, I'm afraid not, we don't have that functionality.

    Let us know if you have any further questions.

    Thank you!