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

    Can we create a form to search in Database ?

    Asked by AppCroNix on July 22, 2017 at 02:40 PM

    Hello,

    We want to create a form to search on a input by user to a set database.

    e.g.:-

    If some one puts his number in form

    Then we what to check if the number exist in database or not.

     

    And give response on it as if it exist message to appeared the number exist.

  • Profile Image
    JotForm Support

    Answered by EltonCris on July 22, 2017 at 09:47 PM

    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 need help with the custom script, just let us know.

  • Profile Image

    Answered by AppCroNix on July 25, 2017 at 05:33 PM

    Yes the widget will work for us, But can we modify it as we need it ?

  • Profile Image
    JotForm Support

    Answered by Mike on July 25, 2017 at 07:01 PM

    The widget itself is not editable.

    If you need to update data, just upload your updated spreadsheet to the widget.