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.
Can I export to spreadsheet and view payment confirmations?Asked by Janet Loos on March 09, 2015 at 12:47 PM
I work for a company that hasn't liked the professional version of wufoo forms. I've used jotform for my company and have loved it (I've only used the free version). Before we switch over, I need to know if we can export entry data to a spreadsheet and if that spreadsheet would show if payments went through or not. (Right now, we have to sign into wufoo, and click on each individual entry to check if paypal entries went through and it has been quite the hassle for us).
Please be noted that the data will be visible in your form's submission page only when the PayPal payment goes through successfully. If the payment was not successful then the submission will be listed separately in "Incomplete Payment" section.
The submission will only be listed in your form's submission page if the payment was successful or you manually complete the payments.
Please be noted that if the payment was successful, the submission data will display the "Payer Info" and "Payer Address" separately. I believe that should be the key for you to figure out if the PayPal submission was successful or not and it will also display you the "Transaction ID" as well. The excel file should display the submissions as shown in the screenshot below:
Hope this answers your query
Do get back to us if you have any questions.
You may also like to take a look at the following guide on how to export your submissions in excel: http://www.jotform.com/help/44-How-to-Export-Form-Data-to-Excel
Please be noted that it is also possible to create an excel report as well and the following guide should help you: http://www.jotform.com/help/101-How-to-create-an-Excel-Report