How to check records if a user is already registered?

  • amelia_l_t
    Asked on June 1, 2015 at 2:48 AM

    I'm considering purchasing JotForm today and I am comparing JotForm to WuFoo. If I am hosting a conference and we build a form so members can register in advance for the conference. Once they arrive, can they sign-in at a computer and a database will know that they have registered and say, "thanks, you've signed in or sorry, no registration found" based on the initial registration records?

    Thanks!

    Amelia Thomas

    334-391-7417

     

     

  • Charlie
    Replied on June 1, 2015 at 9:59 AM

    Hi,

    I believe you can do that, here's an example.

    1. In your Preferences->Form Limits->Unique Question.

    In my case, I want users to only register one email per submission.

    How to check records if a user is already registered? Image 1 Screenshot 50

    2. Navigate to "Advance Settings"->Form Warnings

    How to check records if a user is already registered? Image 2 Screenshot 61

    3. Look for the warning message shown below and edit it.

    How to check records if a user is already registered? Image 3 Screenshot 72

    4. In my case, when user tried to submit again a submission using the same email address, this will be shown. In your case, you can do this as the checking process, just let the user sign up when they arrived in your event using the same email address, if a submission using that email address is already in your records, the warning message will be shown.

    How to check records if a user is already registered? Image 4 Screenshot 83

     

     

    I hope that helps.

    Thank you.

  • amelia_l_t
    Replied on June 1, 2015 at 10:18 AM

    Sorry- I have no idea who changed the title to the question but it does not in any way address my question. Please read the question.

     

    Thanks!

  • Charlie
    Replied on June 1, 2015 at 11:44 AM

    Hi,

    The above workaround is a way for you to check if the user is already registered using a specific field, in this case it's the email address. You just need to put the form live in your event then let the users fill it out again to see if a record exists.

    If you want to have a sign in system in a computer, unfortunately we do not have that kind of function/feature. But, if you have one and you have your own database, then you can send the submission data directly to your database using a PHP script. Here's a guide for that: http://www.jotform.com/help/126-How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP 

    Another workaround, you can also have a Google Spreadsheet, where all the records or submissions are there, you can manually search a user if he/she already registered using the form. Here's a guide for the Google Spreadsheet integration: http://apps.jotform.com/app/google_spreadsheets_integration.

    I hope that helps.

    Thank you.