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

  • Profile Image
    jcutler92
    Asked on January 05, 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?

  • Profile Image
    TREVON
    Answered on January 05, 2018 at 01: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?

  • Profile Image
    jcutler92
    Answered on January 07, 2018 at 11:50 AM

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

  • Profile Image
    Jan
    Answered on January 07, 2018 at 01:55 PM

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

    151535091201-08-driwk.png

    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.gif

    Hope that helps. Thank you.

  • Profile Image
    jcutler92
    Answered on January 09, 2018 at 10:21 AM

    Thank you.


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


    Any suggestions?

  • Profile Image
    Welvin
    Answered on January 09, 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;


    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 

  • Profile Image
    jcutler92
    Answered on January 09, 2018 at 01:11 PM

    1515521502Capture.JPG

  • Profile Image
    Nik_C
    Answered on January 09, 2018 at 02:31 PM

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

    1515526124Screen Shot 2018-01-09 at 8.26

    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!

  • Profile Image
    jcutler92
    Answered on January 10, 2018 at 11:52 AM

    I am still having some issues.


    Which browser do you recommend?  

  • Profile Image
    Jan
    Answered on January 10, 2018 at 01:11 PM

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

    Thank you.

  • Profile Image
    jcutler92
    Answered on January 11, 2018 at 11:05 AM

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

  • Profile Image
    Welvin
    Answered 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