- JotForm SupportjonathanAnswered on February 03, 2018 at 05:48 PM
To achieve this, you will have to create a separate field for the amount that is outside the Payment field.
Because the payment field is locked on by the payment processor (from Payment integration), it is not possible to split the payment data into separate fields in the form submission data/report.
An alternative method although a bit more complex, is to use the submission Email in CSV file format to create the report. The payment field can be stripped into separate data in the email.
But there is a manual step involve here as you will need to manually consolidate the submission email every time to generate the spreadsheet report.
You may want to check on your payment integration instead to create the report.
Example in PayPal integration, you can download and customize the PayPal report.
I hope this help. Let us know how we can be of further assistance.