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.


  • Profile Image

    Fetch many products in Excel or MySQL into Purchase Order form

    Asked by andacami01 on February 02, 2016 at 06:04 PM

    Hi,

    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.. 

    order form purchase order form excel purchase
  • Profile Image
    JotForm Support

    Answered by Chriistian on February 03, 2016 at 01:51 AM

    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.

  • Profile Image

    Answered by andacami01 on February 03, 2016 at 03:45 PM

    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.

  • Profile Image

    Answered by andacami01 on February 03, 2016 at 04:09 PM

    Maybe there is an excel/csv app that I can use - I'll take a look...

  • Profile Image
    JotForm Support

    Answered by Chriistian on February 03, 2016 at 08:14 PM

    You can check out this spreadsheet app automatically converts your excel spreadsheet into a form. 

    http://apps.jotform.com/app/spread2jot 

    Perhaps that can help. Regards.