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.
Submissions Page- search box: Show specific result based on two keywords even if they are not on the same columnAsked by mreade on May 12, 2016 at 07:46 AMMy specific query relates to a problem with the search facility in Submissions for this form:
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.:
I cannot replicate this problem within your form. Here's a screenshot when I searched for Joanna:
Can you check again?
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”
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.
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?
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.