Fetch many products in Excel or MySQL into Purchase Order form

  • Profile Image
    andacami01
    Asked 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.. 

  • Profile Image
    Chriistian
    Answered 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
    andacami01
    Answered 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
    andacami01
    Answered 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
    Chriistian
    Answered 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.