Can we create a form to search in Database ?

  • Profile Image
    AppCroNix
    Asked 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
    EltonCris
    Answered 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
    AppCroNix
    Answered 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
    Mike
    Answered 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.