- reg3141Asked 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?
- JotForm SupportJanAnswered 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.
Hope that helps. Thank you.