Fetch many products in Excel or MySQL into Purchase Order form

  • andacami01
    Asked on February 2, 2016 at 6: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.. 

  • Chriistian Jotform Support
    Replied on February 3, 2016 at 1: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.

  • andacami01
    Replied on February 3, 2016 at 3: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.

  • andacami01
    Replied on February 3, 2016 at 4:09 PM

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

  • Chriistian Jotform Support
    Replied on February 3, 2016 at 8: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.