Make a query to our database from a form input

  • Profile Image
    thomaseude
    Asked on October 05, 2018 at 10:24 PM

    Hello,

    Is it possible to make a query to our PHP database (phpmyadmin) in your form in order to provide to customer further information immediately on this order? Even if we need to coding something, let me know we can hire an IT team for working on it?

    This is an example :

    A customer via your form wants to know his tracking number. For that, the customer just needs to fill out his order number and the form can complete a field of the tracking number thank to a query to our database. We would like to connect your form to our Database and get the tracking number in function of the order number.

    Thanks a lot,
    Thomas

  • Profile Image
    Adrian
    Answered on October 06, 2018 at 06:48 AM

    Hi Thomas,

    Unfortunately, it is not possible to make a query in your database from an input field in JotForm.


    The Spreadsheet to Form Widget is very similar to what you are looking for but you will need to have the database on a spreadsheet file (Excel or CSV) and upload it to the widget.

    Help Article: How-to-Use-the-Spreadsheet-to-Form-Widget


    JotForm also allows the users to build custom widgets for their needs.
    https://developers.jotform.com/widgets


    You can also POST the submission data when the users submit the form and make the query then.
    Help Article: How-to-Post-Submission-Data-to-Thank-You-Page