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.
Feature Request: Form Calculation FormattingAsked by raustin2005 on May 10, 2014 at 03:03 AM
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?
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.
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.
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.
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:
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.