Feature Request: Form Calculation Formatting

  • Profile Image
    raustin2005
    Asked 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?

  • Profile Image
    NeilVicente
    Answered 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
    raustin2005
    Answered 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
    Shadae
    Answered 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
    steve
    Answered 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!