How can you get a cumulative total?

  • gregpare
    Asked on April 25, 2015 at 10:30 PM
    How can you get a cumulative total?
  • David JotForm Support Manager
    Replied on April 25, 2015 at 10:43 PM

    Could you give us details of what you are trying to accomplish? You could use the form calculation widget: http://widgets.jotform.com/widget/calculation

    Here is a guide on how to perform calculation in the form: http://www.jotform.com/help/259-How-to-perform-calculation-in-the-form

    Let us know if you need more help we will be glad to assist you.

     

  • gregpare
    Replied on April 25, 2015 at 11:41 PM

    I am asking a question.  How much money did you save?  Here is the form:http://form.jotformpro.com/form/50994633003958

     

    Pay date doesn't matter.  I want to add up how much is being saved by ALL submissions and display the results like a running total in a thank you email or embed on a web page.

  • raul
    Replied on April 26, 2015 at 11:54 AM

    Unfortunately, I don't think that would be possible to accomplish using only the form builder.

    However, you could use the API to accomplish this.
    Basically, you could retrieve all the submissions you've received in your form and then sum up the value that was selected in the "Amount Saved" field to display the total result in a web page.

    You would need to hire a programmer if you don't have any knowledge about web programming. Or if you're willing to try to do this by yourself, I suggest you to check the links below:

    http://api.jquery.com/jquery.getjson/
    http://stackoverflow.com/questions/18390281/javascript-sum-values-from-json

    Let us know if you need further assistance.