Display numbers in currency format after totaling up checkbox items

  • hsp
    Asked on April 27, 2016 at 2:11 PM

    2.  I would like my numbers to be formatted at $ 0.00 ( Currency format ) can this be done some way ?

    3.  As the users checked more items from a combo box ( Is it possible to add these items up ? )

      Example:

       Choose Service Items

       [*]  Item 1  $ 200.00

       [  ]  Item 2  $10.00

       [*]  Item 3  $3000.00

     

    Calculated Item Line shows   Total Services Selected [ $3,200.00 ]

     

    Can this be done ?

  • Kiran Support Team Lead
    Replied on April 27, 2016 at 2:48 PM

    The total value of the checkboxes can be calculated by assigning the calculation values to the checkbox field and using a Form Calculation widget to perform the calculation. 

    Please see the screenshots below with the assigned calculation values for the checkbox and the calculation to add two checkboxes.

    Display numbers in currency format after totaling up checkbox items Image 1 Screenshot 30

    I've used commaSeparate function in the calculation field to display commas as in the currency. Please try adding all the products in the form to see the difference.

    Display numbers in currency format after totaling up checkbox items Image 2 Screenshot 41

    We do have a widget that formats the number to the required currency format.

    http://widgets.jotform.com/widget/masked_input

     

    I'm not sure how it can be useful to be used in your form.

    I've updated my form with the above changes as well that you may check here.

    https://form.jotform.com/61175293103954

    Please feel free to clone the form to your account to see how the values are set.

    Please get back to us if you need any further assistance. We will be happy to help.