What is the best way to run a report with totals for the individual items?

  • jcutler92
    Asked on January 5, 2018 at 11:10 AM

    Hi,


    I have created a form with Paypal integration.  This form has multiple items on the paypal form.  What is the best way to run a report with totals for the individual items?

  • TREVON
    Replied on January 5, 2018 at 1:17 PM

    I am trying to picture what you intend to achieve so that we can give you a better approach. Its not quite clear what you want to achieve and how you want the reports and the total whether its for quantity of items or cost of the item.

    Would you kindly clarify the above for us to offer a comprehensive solution?

  • jcutler92
    Replied on January 7, 2018 at 11:50 AM

    I am looking for a report of the total quantity of each item ordered. 

  • Jan
    Replied on January 7, 2018 at 1:55 PM

    By default, this is how the payment field looks like on Submissions page and Grid Report:

    151535091201 08 driwk Screenshot 10

    If you exported the submission into an Excel or CSV file, the format will still be the same. The selected products and quantity will not be separated.

    We do have an app called JotPayment History. Here's the link: http://jotpayments.jotform.io/

    1515351305pymnt Screenshot 21

    Hope that helps. Thank you.

  • jcutler92
    Replied on January 9, 2018 at 10:21 AM

    Thank you.


    I tried use that site but it gets stuck on Reading form data.


    Any suggestions?

  • Welvin Support Team Lead
    Replied on January 9, 2018 at 10:41 AM

    Please check your browser console for possible errors.

    https://www.jotform.com/help/453-How-to-get-a-console-report-from-most-common-browsers

    Because I tried the app, it's working;

    What is the best way to run a report with totals for the individual items? Image 1 Screenshot 20


    Once you see an error, please take a screenshot of the whole console area and upload the image to this thread. 

    https://www.jotform.com/help/438-How-to-Post-Screenshots-to-Our-Support-Forum 

  • jcutler92
    Replied on January 9, 2018 at 1:11 PM

    1515521502Capture Screenshot 10

  • Nik_C
    Replied on January 9, 2018 at 2:31 PM

    I tested the app on your account and it worked fine:

    1515526124Screen Shot 2018 01 09 at 8 Screenshot 10

    Could you please try clearing your Browser's cache and then try using the application again.

    Please let us know how that worked.

    Thank you!

  • jcutler92
    Replied on January 10, 2018 at 11:52 AM

    I am still having some issues.


    Which browser do you recommend?  

  • Jan
    Replied on January 10, 2018 at 1:11 PM

    We recommend Google Chrome or Mozilla Firefox. May I know what browser are you using?

    Thank you.

  • jcutler92
    Replied on January 11, 2018 at 11:05 AM

    I have tried both and I am still getting error messages.

  • Welvin Support Team Lead
    Replied on January 11, 2018 at 11:25 AM

    I think there's a glitch when Paypal is used as the payment gateway. My test is using the Purchase Order. I have created a new thread for you so that I can forward this to our backend team. Here's the new link: https://www.jotform.com/answers/1346080