JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
Fetch many products in Excel or MySQL into Purchase Order formAsked by andacami01 on February 02, 2016 at 06:04 PM
Really intrigued with JotForm, I dabble a little in design and have a new requirement to for a user to select any one or more of hundreds of products and quantities therein. I "could" set up many hundreds of products manually and everything will work fine I'm sure. However, the products are constantly changing as are the prices for each of the products. So, if I have a CSV or MySQL "product name, desc, price" can JotForms Purchase Order form grab it? Is there an App/Plugin?
Thanks for looking..
I believe this app may prove useful for what you want to accomplish in your form. http://apps.jotform.com/app/mysql_export Do let us know if you need further assistance.
Nope, just sits there saying "READING PREVIOUS ENTERED DATA, PLEASE WAIT..."
Seems like it is what I want, an automatic way of producing the products on the purchase order form. Seems it might create all of them for me so I don't have to type every one individually but I still have to create the form manually i.e. the form won't go to the DB for the product data. Is that right?
I guess I'm after something more akin to a basic shopping cart that send a order by email.
Maybe there is an excel/csv app that I can use - I'll take a look...
You can check out this spreadsheet app automatically converts your excel spreadsheet into a form.
Perhaps that can help. Regards.