Is there way to get the total order amount of each item in a form?

  • okryantw
    Asked on May 27, 2023 at 3:53 PM

    Hi,

    I have this form
    https://form.jotform.com/231465016440144

    Am I able to get the total amount of each item ordered from all the submissions in this form? how do I do that?

    Thanks!

    Ross

  • Chris_L JotForm Support
    Replied on May 27, 2023 at 5:51 PM

    Hi Ryan,

    Thanks for reaching out to Jotform Support. With Jotform Report Builder, you can easily generate visual reports that are based on your submission data. Let me show you how:

    1. On your My Forms page, select the form that you want to create a report for.
    2. Click on Reports at the top of the page, and then click on Add New Report. Is there way to get the total order amount of each item in a form? Image 1 Screenshot 40
    3. Now, select Visual Report Builder, which will open Report Builder. Is there way to get the total order amount of each item in a form? Image 2 Screenshot 51
    4. Enter a Report name.
    5. Choose a Report Type:
    • Blank – you can add and place charts manually.
    • Extended Report – a single chart is shown per page by default.
    • Compact Report – two charts are shown per page by default.

             6. Then, click on Create and that’s it. You’re done.1655715359 62b0361f0fb9b  Screenshot 62

    For the Extended and the Compact report types, Report Builder will automatically create a chart for each form field or widget on the form. We also have a guide about How to Create a Visual Report with Your Form Submissions that you can check out.

    No, let's change the chart settings in Report Builder.

    • Click on the Gear icon on the right side of the chart to open the Chart Settings.
    • Customize the Metric and Chart Type under the General tab, scroll down until you see the Selected Metric.
    • Select the Amount to display the total amount of each item ordered.Is there way to get the total order amount of each item in a form? Image 3 Screenshot 73

    Give it a try and let us know how it goes.

  • okryantw
    Replied on May 28, 2023 at 3:12 PM

    It helps!

    Thanks a lot.