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

    How can I create a form to search my excel sheet and display the results directly to the form?

    Asked by HospiceVolServices on July 26, 2017 at 11:47 AM

    I would like to use a form for our library where patrons would enter search information they may know like title and have the form populate a box with the result.

    I would like to be able to search by title or author or subject.  

    For example I would like someone to be able to type an author and get results of all the books by that author and a brief description of each book.

    Or, I would like someone to be able to type in subject hashtags and get results for all books that qualify.

     

    The results would not have to be saved.  The user would never see or have access to the excel sheet

  • Profile Image
    JotForm Support

    Answered by aubreybourke on July 26, 2017 at 12:18 PM

    You can create a report of your submissions. I believe the best report for this project is the Grid Listing Report. Because it is searchable.

    Heres how to create a Grid Listing Report:

    #1 Go to "My Forms"

    #2 Select your form and click on "Reports". Then add new report

    #3 Select a Grid Listing

    #4 Configure your report. Note that if you dont want anyone to access your report you shold turn off the Show Edit URLs setting. And also password protect it if you like.

    #5 Take note of the report URL. You can bookmark it ideally. Also note you can embed the report on any website, social media site, etc