How can I pull data from my websites MySQL database into a JotForm table?

  • Profile Image
    reg3141
    Asked on June 14, 2016 at 08:32 AM

    Hi I would like to use Jotform to connect to my websites MySQL database and pull down data into my form in a table style. For example it will pull down data from the product table and display it in a table that allows the user to add quantities before submitting the form. Is this possible?

  • Profile Image
    Jan
    Answered on June 14, 2016 at 05:07 PM

    Unfortunately, this is not possible to achieve in the Form Builder. The available process here is exporting the data from the submissions to your database. Here's a guide about it: How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP

    We have an app called Field Prepopulator that might be helpful for you. This will pre-populate the fields with data when your user opened the form.

    You might also want to check JotForm Webhooks. Here are the guides:
    How-to-Setup-Webhook-with-JotForm
    Webhook-Samples

    Hope that helps. Thank you.