Calculations on Configurable List Widget

  • GetInsured
    Asked on August 20, 2020 at 3:42 PM

    Hello, I'm using the Configurable List Widget mainly because the "Add More" rows feature is vital for the form. However, I'm having trouble getting the total number of items ordered and using that to calculate the total due. 

    Can you help me with this problem? What widget can help me get these results?

    1) Total the number it items ordered in the Quantity field

    2) Calculate a total amount due based on the Quantity * 15 = $TotalDue

    3) Retain the "Add More" feature on the rows

    This is the form I'm using.

    https://form.jotform.com/GetInsured/orders

    Thank you, 

    Charlie

  • Elton Support Team Lead
    Replied on August 20, 2020 at 9:33 PM

    Unfortunately, the configurable list widget doesn't support calculation as of the moment. I can only open the following feature request for this so hopefully, this will be implemented in the future.

    Calculations on Configurable List Widget Image 1 Screenshot 30

    For now, I suggest using the Input Table field. This supports calculation but you will have to define how many rows you want to allow since this doesn't support dynamic fields. Here's a cloned version of your form which I modified with Input Table and added the calculation.

    https://form.jotform.com/202327742779968

    You can clone this form back if you like. Guide: https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL

    You can check the calculation formula in the Total Due field. I added all the quantity fields and multiplied by 15.

    Calculations on Configurable List Widget Image 2 Screenshot 41