multiplier field calculation

  • paulmanton
    Asked on August 14, 2015 at 4: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

     

    Jotform Thread 638433 Screenshot
  • paulmanton
    Replied on September 4, 2015 at 6:54 AM

    bump

  • Charlie
    Replied on September 4, 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.