JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
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?
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!
So could I create a new form and have it lookup the data from an excel form?
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.