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

    Is it possible to search for a submitted form in 'Submissions' via URL query?

    Asked by Kiltox on August 21, 2014 at 05:34 AM

    Hello all,

     

    I see that it is possible to search through submissions via typing in data into the search field at the bottom of the 'submissions' page as per the below screenshot

     

    Would it be possible to automatically search this field by entering data into the submissions view URL so that only one result is shown? We'd be looking to auto-search by the property reference number field ('Property Reference (K#)')

     

    I am imagining it would look something like this - but I do not know what the search box is called!

     

     

     

     

     

    The reason for this query is that we are trying to automate as much of the form as possible via our existing system.

     

    Currently the person using the form has a button they press on another existing computer system which partially auto-populates the Jotform via a URL - example being

     

     

     

    We would therefore like to be able to have the same ability to auto-find the submitted form in submissions via the same method of a URL query at the touch of a button (link)

     

    Can you confirm if this is possible? This would be a bit of a make-or-break for us upgrading to the paid account so a solution would be great!

    Page URL:
    http://www.jotformeu.com/form/42233747886364

    Screenshot
  • Profile Image

    Answered by MartinSA on August 21, 2014 at 05:58 AM

    Just as i posted in a previous topic, filtering the reports online exactly like this would be really a great addition! 

  • Profile Image
    JotForm Support

    Answered by ashwin_d on August 21, 2014 at 10:52 AM

    Hello Kiltox,

    Unfortunately we do not have such feature. It is currently not possible to make a search in the form submission through the URL parameter query.

    I am not sure how secure it will be because it will expose all your submission data of your form. If you want I can send a feature request to our back end team.

    For now I would suggest you to take advantage of our available "API" to build your own feature you want. Please take a look at our API docs here:  http://api.jotform.com/docs/ 

    Thank you!

  • Profile Image
    JotForm Support

    Answered by ashwin_d on August 21, 2014 at 10:58 AM

    Hello Kiltox,

    I have created a feature request to our back end team. We will get back to you as soon as we have any update from them.

    Thank you!

  • Profile Image
    JotForm Support

    Answered by steve on August 21, 2014 at 11:30 PM

    Hello Kiltox-

    As per my colleague mentioned, we don't immediately offer the ability to filter submission results based upon keywords in a query string. However, you might be able to accomplish the same thing via our API.

    http://api.jotform.com/docs/#form-id-submissions

    It does have the option to filter the queried results, but unfortunately that appears to only be at the meta level- time submitted, ticket number, etc. What could be done is set up a system to parse the JSON text on your end, and select the result you want.

    Or, if you have the specific submission ID, then it can be queried it directly:

    http://api.jotform.com/docs/#submission-id

    Let us know if that might help resolve the issue.

    Kind Regards