How to calculate the total number of points awared to employees for each form submission?

  • Profile Image
    Asked 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? 


  • Profile Image
    Answered 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 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
    Answered 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.