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

    How can I create a Successful Order Report Based on Identity

    Asked by johnlprice on December 03, 2014 at 07:27 PM

    What I am wanting to try and do is sell a report. A Police Report online, for instance user wanting a police report would enter specific information and if the identity is verified, they are taken to a page to pay for report. The report is then able to be downloaded or sent to there email address.

    Form Entries would be:

    1

    Enter Last Name

    Last Name
    2

    Enter Date

    Date of Accident
       
    and

     

    3

    Enter One Of The Following Fields

    Driver's License #
    Report # (also known as Local Code)
    Officer's Badge #

    What is the best and easiest way to link the data needed to a report in the database and is there a way if the information is not ready yet that the person could be notified by email when it was.

    See www.buycrash.com for the perfect example. 

     

    Page URL:
    https://buycrash.com/en/quick_search/select_state

    create name table license www
  • Profile Image
    JotForm Support

    Answered by Welvin on December 03, 2014 at 11:46 PM

    Hi,

    I'm not sure how this works, but checking the website: https://buycrash.com/en it allows you select a state. I have selected a state and it says no report. This means, that the report are added to the backend and users would be able to select it when available. 

    You can add the same function to the form, but the data must be added to the form. You can use our conditional logic to show/hide specific set of fields. For example, this guide: http://www.jotform.com/help/297-Show-or-Hide-multiple-fields-at-once-using-form-collapse-tool

     

    What is the best and easiest way to link the data needed to a report in the database and is there a way if the information is not ready yet that the person could be notified by email when it was.

    -For database management, you can forward form submissions to your MySQL Database by following this guide: http://www.jotform.com/help/126-How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP.

    -For sending information, maybe you could ask their email address and send them when report is available. Well, you have to do this manually because I don't think automation works in the form.

    Thanks