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

    Submissions Page- search box: Show specific result based on two keywords even if they are not on the same column

    Asked by mreade on May 12, 2016 at 07:46 AM
    My specific query relates to a problem with the search facility in Submissions for this form:
    https://form.jotformeu.com/52532755614355
    For instance, if I type in the first and family names of applicants such as "Sally Day" or "Joanna Williams" or just "Williams" or just "Joanna" I receive a message saying: "No results to display. Check your search query or time frame options" even though these people have submitted applications.
    Please could you help? I don't have this problem with this form for e.g.:
    https://form.jotformeu.com/50824081567356
    Thanks
    Michael Reade
    no results form submissions search submissions
  • Profile Image
    JotForm Support

    Answered by Welvin on May 12, 2016 at 08:25 AM

    I cannot replicate this problem within your form. Here's a screenshot when I searched for Joanna:

    Can you check again?

  • Profile Image

    Answered by mreade on May 12, 2016 at 09:44 AM
    If I put Joanna in I get this record (screenshot below). Although a Joanna Zakrzewska was also a co-applicant in this particular submission so I can see why the search has produced this record.
    If I put in her full name “Joanna Williams” (which I would do in practice) I get “no results to display”
    [cid:image002.jpg@01D1AC55.79ED5690]
    Michael
    ...
  • Profile Image
    JotForm Support

    Answered by Welvin on May 12, 2016 at 11:18 AM

    That is because both aren't on the same field. You have the first and last name as separate fields. Unfortunately, the search box in the form submissions page is not yet program to search by a group of terms, no filter. The page will try to look up the columns and show you the result if there's anything that matches the keyword. 

    I would suggest searching for their email address instead. That should show you the correct submission.

  • Profile Image

    Answered by mreade on May 12, 2016 at 11:44 AM
    Thanks – I will use email addresses to locate exact records but I would have the ability to search for groups of terms. This will make things much easier for us. Can this be put forwarded for development?
    Michael
    ...
  • Profile Image
    JotForm Support

    Answered by Welvin on May 12, 2016 at 12:47 PM

    You're welcome.

    Sure. I have now forwarded this thread to our developers as a feature request. If there are updates, you should know it through this thread.