- sjakubikAsked on October 01, 2015 at 03:33 PM
My form (http://www.jotformpro.com/form/52654843300956) has two ways to pay: by check or by PayPal. When check is selected, the total works on the form for the user and in the confirmation email that they receive. However, when I pull a report (http://www.jotform.com/excel/52656833793064), the check totals are not visible even though that box is selected on the report options. What am I doing wrong? Thanks!
- JotForm SupportjonathanAnswered on October 01, 2015 at 06:42 PM
I was able to see an the old submissions of your jotform http://www.jotformpro.com/form/52654843300956 that have check option selected as payment but was not available in the submission data.
If they are not in the View Submission data they will not appear also on any report.
I made a test submission again now using your form, but the same issue did not happen.
I can see my test submission in your form submission data.
I was able to figure out what had happened why those 2 old submissions by check is not on the Submission data.
It was because prior to Sept 24th you have not yet properly setup the condition that Calculate values base on payment by check.
I was able to see this in the Revision History of your form.
as you can see on the image above, the Pay by Check doesn't have yet a Total when using the form.
As it is now, it seems the form is now working as intended after you have made the update/revisions.
If an end-use will now choose Payment by Check, you should now be able to see the data in your Excel Report and in the Submission data of the form.
Hope this help. Please let us know if issue still persist.