User friendly seach form

  • billmy
    Asked on February 24, 2021 at 8:49 PM

    Using Jotform,


    There the a user friend form you can create to return a result. After the database has thousands of records.

    The database has the fields ID, Name, Address, DOB

    Using a user friendly front end type in a name and it returns the results of all record matching that name.

  • Ashwin JotForm Support
    Replied on February 25, 2021 at 3:22 AM

    Unfortunately it is not possible to create a form to search database based on any text. I would also suggest you to please take a look at our "Spreadsheet to form" widget and see if that fits into your requirement.

    You can upload an Excel file with all the data and a unique column data that could be the ID field. When the user input their ID in widget on form, it will fetch the existing data from the uploaded Excel file and display in form fields. You may like to take a look at the following guide which should help you: https://www.jotform.com/help/442-how-to-use-the-spreadsheet-to-form-widget

    Hope this helps.

    Do get back to us if you have any questions.