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.


  • Profile Image

    Total Paid by Check Not Visible on Report

    Asked by sjakubik on October 01, 2015 at 03: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

    Page URL:
    http://www.jotformpro.com/form/52654843300956

    check not visible visible excel revision history calculation value
  • Profile Image
    JotForm Support

    Answered by jonathan on October 01, 2015 at 06: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.

     

    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.