How to separate products and prices in separate cells in the reports?

  • Profile Image
    Dalanamoore
    Asked on April 23, 2019 at 08:40 PM

    I want to be able to generate reports based on items purchased through jot form. People have bought books, t-shirts, tickets and more but when I want to get totals for a specific item, I can't. The self generated spreadsheet lumps all of the purchased items in one column, which defeats the purpose of this spreadsheet.



    This is a re-post of a comment on How to Use Visual Report Filters?

  • Profile Image
    roneet
    Answered on April 23, 2019 at 10:39 PM

    You may check the Grid report:

    https://www.jotform.com/help/105-How-to-Create-a-Grid-Listing-Report

    To see the total of each product separately, you can configure the products outside of the payment field using the traditional elements like dropdown for quantity, Image element if you want to show the picture of the product, text box, multiple choice to select the sub-products. Then pass the total amount to the payment field.

    Please check this guide:

    https://www.jotform.com/help/275-How-to-Pass-a-Calculation-to-a-Payment-Field

    Let us know if you have further questions.

    Thanks.