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.
Is it possible to sum up all previously submitted figures with the new entry on jotform?Asked by MissMarudek on January 22, 2015 at 06:51 AM
Can someone please tell me if the following is at all possible with JotForm?: as the charity I work for doesn't have much permanent admit staff to deal with volunteer expenses and book-keeping, we were thinking of creating and putting on our website a list on which each volunteer could input the details of their claim themselves. Is this type of user-generated form possible with JotForm?
And if it is, is there a way to have the form automatically sum up the figures every time there is a new user input, so that we can always keep track of the volunteer expenses total for the whole organisation?
Any help would be very much appreciated.
Based on what you have said it would not be possible without some integration like a Google Spreadsheet where you would be able to check the values entered.
Do note that JotForm can only be used to input / capture the data entered by a user, not to retrieve it and do calculations based on that as well, but as mentioned you can do calculations in Google Spreadsheet and use jotform to capture the required data.
If you have a website, then there would be a way to capture old sums and pass them over for new re-calculation.