Can I cross reference a database to my form to check the username?

  • thrivesocial
    Asked on December 23, 2017 at 8:18 AM

    Hi JotForm Support, 


    I have searched all online and I want to purchase JotForm. However there's one question that I can't find the answer for. 

    Is it possible in jotform to check matching database value. For example: Check the username in the database before proceeding, so when people haven't submit that username they can't proceed and shows "Sorry, username is not found. Are you sure you are our client?" -- Something like that. 

    Thank you and looking forward to your reply.


    Eric

  • Richie JotForm Support
    Replied on December 23, 2017 at 8:41 AM

    You can create a condition in where its gets the value of the user. Either by using the Show/Hide Field or Skip to / Hide a page.

    Here is a sample skip to/ hide a page condition.

    If the name is not equal to 1234 it will skip to the error page.

    Can I cross reference a database to my form to check the username? Image 1 Screenshot 30

    Here is a sample screen cast.

    Can I cross reference a database to my form to check the username? Image 2 Screenshot 41

    You can check this guide in creating smart forms using conditional logic. Smart-Forms-Using-Conditional-Logic

    Here is my sample form, you can clone it to reference my sample.

    https://form.jotform.com/73563846583974

    A guide on cloning forms. How-to-Clone-an-Existing-Form-from-a-URL

    Please let us know if we can be of further assistance.

  • thrivesocial
    Replied on December 23, 2017 at 9:00 AM

    Thank you but what I need is a dynamic value. So here's what I'm trying to achieve: 

    1. User register new name in Form A with "1234" -> It's saved in the database

    2. User submit name in Form B that's been on Form A database ("1234") -> proceed

    3. User submit name in Form B with "6789" -> Sorry, name is not found 


    Is this possible? Cheers.

  • Ardian_L
    Replied on December 23, 2017 at 10:13 AM

    We do not have a built-in feature with that functionality but you can definitely use the form source code as the fundamental structure. Then modify the form source code and add your custom scripts that would perform the database checking.

    Here's how to get your form source code: http://www.jotform.com/help/104-How-to-Download-a-Source-Code-of-your-Form

    This PHP code will help: https://stackoverflow.com/questions/7286966/php-how-to-check-if-id-in-database-exists

    Alternatively, if you want to use a spreadsheet file as the database containing the IDs, you can use this widget https://widgets.jotform.com/widget/spreadsheet_to_form.

    If you have any other question please let us know.