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

  • Kiltox
    Asked on August 21, 2014 at 5: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!

    Jotform Thread 418836 Screenshot
  • MartinSA
    Replied on August 21, 2014 at 5:58 AM

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

  • Ashwin JotForm Support
    Replied 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!

  • Ashwin JotForm Support
    Replied 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!

  • Steve VP of Sales Operations
    Replied 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