How do I make my Configurable List widget sum the values in a column?

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

  • Profile Image
    ashwin_d
    Answered on June 26, 2016 at 09:18 PM

    Hello Chris,

    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.

    Thank you!

  • Profile Image
    Chris 
    Answered on June 26, 2016 at 10:45 PM
    Hi Ashwin, this is my form…

    https://www.jotform.com//?formID=61711149389865



    ...
  • Profile Image
    Boris
    Answered on June 27, 2016 at 02:58 AM

    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:

    https://www.jotform.com/help/259-How-to-perform-calculation-in-the-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:

    https://www.jotform.com/help/343-How-to-Perform-Form-Calculation-in-the-Matrix-Field

    If you run into any issues with setting up your calculations, please let us know. Thank you.