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

  • Profile Image
    thrivesocial 
    Asked on December 23, 2017 at 08: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

  • Profile Image
    Richie_P
    Answered on December 23, 2017 at 08: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.

    Here is a sample screen cast.

    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.

  • Profile Image
    Ardian_L
    Answered 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.