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 calculate the total number of points awared to employees for each form submission?

    Asked by vim00010 on September 30, 2016 at 06:00 AM



    I have created a form for employees to submit business improvement ideas, the idea is that we will award points for ideas that get approved. From 25-100 points depending on the quality of the idea. 

    The points, once awarded, can be "spent" on various prizes, including vouchers, wine etc. 

    Obviously some people chose to keep their points to save them up, so that they can eventually claim a bigger/better prize. 

    Is there a way of jotform keeping count of how many points each employee has? Then maybe I can create another form where they can spend the points? 


    Page URL:

  • Profile Image
    JotForm Support

    Answered by Kiran on September 30, 2016 at 10:29 AM

    Unfortunately, there is no built-in feature available for calculating the total of a field from the form submissions. You may download the report to Excel and run a chart or pivot table to see the number of points available for each employee.

    Hope this information helps! 

  • Profile Image

    Answered by vim00010 on September 30, 2016 at 10:33 AM

    So could I create a new form and have it lookup the data from an excel form? 

  • Profile Image
    JotForm Support

    Answered by Chriistian on September 30, 2016 at 12:54 PM

    It is currently not possible to lookup data from an excel form in JotForm. There is no current feature available in JotForm that can help you lookup data. 


    Do let us know if you have any further questions.