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

    Purchase Order: Import data from Excel

    Asked by linathany on March 17, 2015 at 06:07 PM

    I'm trying to import the purchase order data portion of my form from excel/csv but only columns for text boxes are displayed. Is there a workaround?



    This is a re-post of a comment on Import App: Easily import your Excel or CSV data into JotForm

    excel CSV purchase workaround
  • Profile Image
    JotForm Support

    Answered by steve on March 17, 2015 at 10:59 PM

    Hello,

    Can you let us know the form you're working with? I don't believe you can import purchase order data into our payment field widgets, such as PayPal. Some details are processed entirely on the payment vendor side. We just receive confirmation of the transaction, as I understand it. We need more info to look into this further though.

  • Profile Image

    Answered by linathany on March 18, 2015 at 09:27 AM

    Hi,

    I'm not using any of the widgets that use authorized payments (no paypal, clickbank, worldpay, etc.)  I'm just using the purchase order in the payment widgets which you can modify to contain different product fields and add up a total.  I was using the form to try to create multiple invoices at once by importing excel/csv data. 

    When i export data from submissions I've filled out manually, there is a column with purchase order info.  If there is a way to import that data via excel, that would be great.

     

    Thanks.

  • Profile Image

    Answered by Shadae on March 18, 2015 at 12:45 PM

    Hi linathany,

    Thank you for providing us with more information regarding the payment tool that you are currently using.

    After doing some test, the Purchase Order field does not have the option to have data imported. I have sent a request to a developers to see if this can be implemented.

    Any update on the request will be posted on this thread.

    Thank you.

  • Profile Image

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

    This would be a fantastic feature, will devs be producing something?

  • Profile Image
    JotForm Support

    Answered by BDAVID on February 03, 2016 at 10:06 PM

    @andacami01, unfortunately, there is no any update about the progress of this request. This feature is not currently in a priority list, so there is no estimated time-frame for it's implementation.