How to show the summed up total value of a field from all submissions into a thank you page?

  • Profile Image
    Greg Pare
    Asked on April 25, 2015 at 04:32 PM

    I have a form that I am challenging people to save money (honor system).  How much have you saved?  How can I show all people that submit a composite total or "scoreboard"?  I don't care about the dates, just the composite total saved.

  • Profile Image
    Answered on April 25, 2015 at 07:22 PM

    Hi there,

    If I understand you correctly, you would like to create a report that shows the data submissions in a chart or in a table. Am I correct?

    If so, please check this guide about creating a visual reports. You can also create an excel file.

    You can check the reports section for further information.

    Hope this helps. Thank you.


  • Profile Image
    Answered on April 25, 2015 at 07:26 PM

    I want to TOTAL the tabulations automatically.  I don't care about the individual paydays, simply how much has been saved TOTAL by all submitters and link them to the results in the Thank You email.

  • Profile Image
    Answered on April 25, 2015 at 11:42 PM

    I see what you mean, summing up the total of an specific field(column) of all submissions would required custom programming.

    Basically send submissions to your own database:

    Creating a SQL query to sum up all the contained values, then creating a PHP page where the data will be displayed, and then redirect when form is submitted to that thank you page:

    So, I would recommend you to hire a programmer to help you accomplish this complex task, since as far as I know, it is not possible to accomplish with our current features.