What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.

  • Profile Image

    Is it possible to have a calculated field with thousands mask?

    Asked by pablogutierrez on June 05, 2017 at 12:41 PM

    Hi Jotform Team!

    We have created a calculated field and it works great. However, we have 2 questions:

    * How can we set "thousands" in the number fields (example: 5000 to 5.000). We used to do it with masks but the new Jotform version doesn't show it.

    *  How can we set "thousands" in the calculated field (example: 5000 to 5.000). Same issue as above.

    Thanks a lot.

  • Profile Image
    JotForm Support

    Answered by AIDAN on June 05, 2017 at 02:09 PM

    While I am not aware of an option that allows you to add a comma separator to the number field, here is how to achieve that using the form calculation widget:

    1. Click on the 3 dots icon as shown here:

    2. Select the commaSeparate() function as shown here:

    This allows you to add any field inside this function, including this form calculation field itself.

    I hope this helps. If you need further assistance please let us know. Thank you.

  • Profile Image

    Answered by pablogutierrez on June 05, 2017 at 02:57 PM

    Hi Aidan,

    Thanks for your answer. We did what you said for the calculated fields but now they are blank and not showing any result: https://form.jotformz.com/71518007634655

    We need to comma separators and 0 decimal places.

    Can you please check?

    Thanks a lot.

  • Profile Image
    JotForm Support

    Answered by BDAVID on June 05, 2017 at 05:58 PM

    Please try the following:

    1) Delete the  "Precio Establecido" text field.

    2) Add the Masked Input widget instead, and name it "Precio Establecido": https://widgets.jotform.com/widget/masked_input 

    3) Add a another Form Calculation widget(and hide it),and name it as "Precio", which you will use to obtain the value entered in the Masked Input widget.

    4) Update your calculations, and make sure to put the formulas in parenthesis, so you will have double parenthesis for them to work, example:

    5) In order to avoid zero decimal places, follow these steps:

     1. Click on the 3 dots icon as shown by my colleague:

     2. Then click on OPTIONS, and set the decimals to zero:

    Here is the result of my clone version: https://form.jotformpro.com/71556566280967 

    You can clone and use it if you want to: https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL 

    Let us know if you need more help.

  • Profile Image

    Answered by pablogutierrez on June 05, 2017 at 07:56 PM

    Hi BDavid,

    Thanks for your specific tutorial! It worked PERFECTLY.

    Thanks again.