-
reg3141Asked on June 14, 2016 at 8: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?
-
JanReplied on June 14, 2016 at 5: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-SamplesHope that helps. Thank you.