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

    How to check records if a user is already registered?

    Asked by amelia_l_t on June 01, 2015 at 02: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

     

     

    JotForm sign-in thanks register
  • Profile Image
    JotForm Support

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

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

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

    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.

     

     

    I hope that helps.

    Thank you.

  • Profile Image

    Answered by amelia_l_t on June 01, 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!

  • Profile Image
    JotForm Support

    Answered by Charlie on June 01, 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.