Total Paid by Check Not Visible on Report

  • sjakubik
    Asked on October 1, 2015 at 3:33 PM

    Hi!

    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!

    Susanna

  • jonathan
    Replied on October 1, 2015 at 6:42 PM

    Hi Susanna,

    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.

    Total Paid by Check Not Visible on Report Image 1 Screenshot 50

     

    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.

    Total Paid by Check Not Visible on Report Image 2 Screenshot 61

    I can see my test submission in your form submission data.

    Total Paid by Check Not Visible on Report Image 3 Screenshot 72

     

    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.

    Total Paid by Check Not Visible on Report Image 4 Screenshot 83

    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.