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 do I make my Configurable List widget sum the values in a column?Asked by Chris on June 26, 2016 at 07:34 PM
I am creating a reimbursement form for fees paid to match officials for each round of football matches. I want tthe team manager to be able to add a new row for each round they have played. I them need the not form to total the $ for each round. However, i cannot workout how to get column totals (and then use these field values to calculate a total amount due)?
On which form you are currently working? I did check but you do not seems to have any form created yet.
Unfortunately it is not possible to achieve your requirement with dropdown field. Can you please let us know how to calculate the total $? Please explain the formula how you want to calculate and how you want the users to add data of each round of football matches. We will try to help you achieve it.
We will wait for your response.
Hi Ashwin, this is my form…
Calculations are not available inside widgets such as the Configurable List widget that you are using.
Calculations are available only for calculating values of regular form fields, such as Number fields, Text Box fields, Matrix fields, etc. You can see the following guide on how to perform calculations on a form:
This means that your manager will not be able to add any number of rows they would like, such as they are currently doing with the Configurable List widget. Instead you will have to create fields for each "row", by using ordinary form fields such as a Matrix field or multiple Number fields, and then your manager will be filling out these fields.
If you want to use a Matrix field, here is a specific guide about performing calculations on values of a Matrix field:
If you run into any issues with setting up your calculations, please let us know. Thank you.