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

    Feature Request: Form Calculation Formatting

    Asked by raustin2005 on May 10, 2014 at 03:03 AM

    Hello,

    While i am familiar with adding an input mask to a field such as ##,###, when adding a caclulated condition. The input mask does not seem to take hold. This is a non-editable field. Ex. (When i have a field with an input mask of #,### and a user types in 1000, the result is "1,000". However when this fields result is based on a calculation of a condition the result is "1000") Basically, the input mask is not being honored when a fielde is automatically calculated. Is this a bug, or am i doing sometihng incorrect?

    Screenshot
    input mask hello editable and calculated condition
  • Profile Image
    JotForm Support

    Answered by NeilVicente on May 10, 2014 at 07:04 AM

    That is not a bug, as the calculation widget only takes numeral values from the operands (when doing arithmetic calculations not string concatenation).

    Therefore, the input mask CANNOT be retained. Sorry about that.

  • Profile Image

    Answered by raustin2005 on May 10, 2014 at 07:59 AM

    Ok thanks for your answer. At least i can stop looking for a solution.

    Perhaps the moderators can add a "Format" or "Text" formlua within a condition, which would be great, such as Text(TotalCost,"##,##") or Format(TotalCost,"##,###") which would be great for a ton of field types.

  • Profile Image

    Answered by Shadae on October 14, 2014 at 10:57 AM

    Hi raustin2005,

    To confirm, you would like the option to determine the format of the calculation field?

    I have passed this requested on to our development team. There is however no estimate on when this will be implemented, and if it will be.

    Any update regarding the request will however be posted on this thread.

    Thank you.

     

  • Profile Image
    JotForm Support

    Answered by steve on October 14, 2014 at 08:50 PM

    Hello-

    I was able to get this to work by adding input masks to both input and output fields. Would this work for your situation?

    Set up basic calculation:

    Result, input mask is used in the output:

    Sample form:

    https://www.jotform.com/form/42867692450969

    Please take a look and let me know if that will work, or if you need something different. If so, please include the form ID you're working with.

    Thanks!