Can JotForm calculate a total on my forms submissions page?

  • Profile Image
    gcchapel
    Asked on November 05, 2015 at 07:19 PM

    When viewing my forms submissions, I see the total of submissions (down in the bottom right corner). Is there a way to also see, at a glance, the total quantity calculated from all the forms that have been submitted. For example, I may have five orders (submissions), but each submission could have been for a quantity of 2, for a total of 10 people attending.

    Thank you.

  • Profile Image
    jonathan
    Answered on November 06, 2015 at 12:02 AM

    You can create Reports i.e. Excel Report using the form Submission data.

    Then create a running Total function in the Excel report. 

    This will give you the current running total quantity/number.

    OR

    You can use Google Spreadsheet integration, and use spreadsheet data to get universal calculations or running total.

    Hope this help. Let us know if you need further assistance.

  • Profile Image
    gcchapel
    Answered on November 06, 2015 at 01:05 AM

    Thanks for the quick reply. I am aware that I can export the data into other formats to obtain the total. I was hoping there was a way I could see such a calculation within JotForm. I guess not?

  • Profile Image
    jonathan
    Answered on November 06, 2015 at 01:15 AM

    Thank you for explaining further. 

    I am not sure if the JotForm Form Analytics is similar to what you were looking for. 

    You may want to check it here for more datails.

    -Realizing-the-Power-of-Form-Analytics

    Let us know your thought on this.