How to create a reliable calculated field with currency symbol?

  • Profile Image
    sebastienhersent
    Asked on February 18, 2018 at 10:30 PM

    Hello, 

    Please Show me how get a relaible calculated field please.

    When I write 

    Quantity = 3

    Price per unit = 11,11


    TOTAL = 3333

    I tested 3 ways...

    1st way, I used "maked input" field to have dollar values, and make conditions but total field doesn't appear...


    2nd way, I used basic field but total is wrong when I use comma for decimal separator (Field : price per unit # 2) and I can't ban comma in this field... 


    For exemple :

    Quantity # 2 = 3

    Price per unit # 2 = 11,11 $


    TOTAL # 2 = 3333 $     ????  (you see that...)


    3rd way, I used Form Calculation Widget, but it looks like 2nd way. 

    If you use the point like separator it is ok but not with the comma... 

    However users are allowed to write in 2 ways...

    It doesn't matter if we use comma or point but if we must use the point, please show me how to ban comma option (in field "price per unit") ?


    Also It could be interesting to have $ symbol in fields.

    Thanks a lot for your help !



  • Profile Image
    ashwin_d
    Answered on February 19, 2018 at 06:54 AM

    Please note that you can add a textbox field for quantity and "Masked Input" widget for price per unit. You can then add "Form Calculation" widget to calculate the total amount. You can also add "$" in form calculation widget to display the currency symbol. You do not have to add any condition for calculation but just add the form calculation widget to achieve your requirement. Please check the screenshot below:

    1519041065calc.gif


    Please take a look at the following cloned form and see if it works as expected:   https://form.jotform.com/80492880424965 Feel free to clone this form for a closer look. The following guide should help you in form cloning:  https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL

    Hope this helps.

    Do get back to us if you have any questions.

  • Profile Image
    sebastienhersent
    Answered on February 20, 2018 at 09:35 AM

    Thanks for your answer, 


    Last things, I'm not able to make the 3rd field (result) just read only.


    Despite select option "Result field is read only ", I am able to change result.


    thank you for our help.


    Have a nice day !

  • Profile Image
    ashwin_d
    Answered on February 20, 2018 at 11:07 AM

    If you select option "Result field is read only" of form calculation widget, that should solve your problem. I enabled it in my test form and I was unable to edit the value in form calculation widget of form. Please check the screenshot below:

    1519142798readonlyCalc.gif

    Here is the demo form:  https://form.jotform.com/80492880424965

    Do try it our and get back to us if the issue persists. You may also like to let us know the form in which the read only option is not working and we will take a look.

    We will wait for your response.

  • Profile Image
    sebastienhersent
    Answered on February 20, 2018 at 02:38 PM

    Perfect it's OK !


    Thanks a lot !