Can JF's collect the forms and put into a database of some sort?

  • Garett Chipman
    Asked on December 7, 2016 at 5:33 PM

    Have a scenario where technicians in the field have to fill out forms for inspection. When they come back, can the forms be populated into a database or searchable solution for results?

     

    Thank you.

     

    Garett

  • Support_Management Jotform Support
    Replied on December 7, 2016 at 9:20 PM

    Hey Garett, the answer to your question highly depends on what your end goal would be. Since you never provided more info on what you're trying to achieve, I'll just list down some scenarios:

    1. Can the forms be populated into a database...

    That depends, what is your database? If you're using MySQL then we have a very detailed guide on how this can be done using PHP.

    Complete guide: How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP 

    2. ...or searchable solution for results

    If all you need is a way to search through your Submission Data, then we already provide that. Just go to your Submissions Page, and use the search textbox at the bottom.

    Can JFs collect the forms and put into a database of some sort? Image 1 Screenshot 30

    Related guide: How-to-View-Form-Submissions 

    But if you need someone else (not you, as the form/account owner) to search through submissions, then you may use the Grid Listing Report to present your Submission Data. Here's an example:

    Can JFs collect the forms and put into a database of some sort? Image 2 Screenshot 41

    Complete guide: How-to-Create-a-Grid-Listing-Report