Calculate totals after submission

  • Profile Image
    jcrowe
    Asked on August 10, 2016 at 10:23 AM

    I have a form that I'm that record amount of money raised and location it was raised in.  This form will be used across our company.  We would like to easily be able to calculate the total amount of money raised at each location.  I know we can do this in Excel, but I was really hoping Jotforms had something pre-built to do this.

    In researching, I came across this forum post...

    https://www.jotform.com/answers/507560-Calculate-totals-after-submission

    Is this still accurate?  

      If not, how do l calculate the totals, from all reports?

      If so, is there any talk of amping up the visual reports so they could calculate these totals?  

     

    ~Jason

  • Profile Image
    Charlie
    Answered on August 10, 2016 at 11:23 AM

    Unfortunately, it is not possible to total all total values in your submission using the form builder or the current features that we have. But, there are a number of ways on how you can manage the data. 

    Aside from the reports that you may already know that is mentioned in this guide: https://www.jotform.com/help/326-How-To-Create-Form-Reports-in-JotForm. We have other app integrations that may help you further. One of the famous app integration that we have is the Google Spreadsheet integration, that allows you to have a real-time list of your submissions in a spreadsheet, from there you can easily refer to the columns or cell, apply a formula or filter to sort the sum of each submissions' total value per location.

    You can also check the other app integrations that we have related to this data management/analytics: https://apps.jotform.com/category/analytics_and_reporting 

     

    If you are familiar with programming and developing via API, then you can also use JotForm's API to simply fetch information from your submissions and create your own data analytics page. You can check our API documentation here: http://api.jotform.com/ 

    I hope that helps.