multiplier field calculation

  • Profile Image
    paulmanton
    Asked on August 14, 2015 at 04:20 AM

    when using the "filed multiplier" widget for the user to add new lines/text boxes is it possible to have these new additional lines all calculated in a sum to show in a total

     

  • Profile Image
    paulmanton
    Answered on September 04, 2015 at 06:54 AM

    bump

  • Profile Image
    Charlie
    Answered on September 04, 2015 at 10:19 AM

    Hi,

    Apologies for the delay in response, I'm not sure why this thread as skipped.

    Regarding your question, unfortunately, the field multiplier cannot be used to sum all of the input fields. This is because the number of fields dynamically changes and we cannot set a specific formula that will dynamically get those values.

    But I have some suggestions that might work, you can check this guide regarding the use of Matrix fields and conditionally use formulas inside it: https://www.jotform.com/help/343-How-to-perform-form-calculation-using-the-Matrix-Field- 

    Another widget that you can use is the Spreadsheet widget: http://widgets.jotform.com/widget/spreadsheet.

    You can also use conditional logic to make the plain form fields to hide, show and sum the fields.

    Here's a sample form: http://form.jotformpro.com/form/52464119760961?. I used conditional logic to show and hide the additional text boxes when the check box is selected. Then I used the form calculation widget to sum them all.

    I hope that helps.