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.
Purchase Order: Import data from ExcelAsked 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
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.
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.
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.
This would be a fantastic feature, will devs be producing something?
@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.