What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

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

    Asked by Greg Pare 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.

    Page URL:
    http://form.jotformpro.com/form/50994633003958

    Submissions app chart all submissions report visual report excel
  • Profile Image
    JotForm Support

    Answered by Jan 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 by gregpare 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
    JotForm Support

    Answered by BDAVID 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: https://www.jotform.com/help/126-How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP

    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: https://www.jotform.com/help/38-Redirecting-Users-to-a-Different-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.