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.
How can I pull data from my websites MySQL database into a JotForm table?Asked by reg3141 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?
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.