Form Builder: Add new field to handle currency formatting

  • ROCGPerth
    Asked on July 11, 2017 at 4:30 AM
    It would help if you could just include a masked input option for the existing number field. Unfortunately, you cannot use a Masked Input Widget field in a calculation, only as a total of a calculation as mentioned above. I still baffled by the fact that there is soooo much functionality in JotForm but I cannot display my dollar amounts in a currency format. No, I cannot use the Masked Input widget in my scenario. The alternative is to fix the Masked Input widget so that it CAN be used in calculations - either way, can we PLEASE have some way of displaying monetary amounts correctly. We are Accountants so we when we publish forms to end users, it looks very silly us not using decimal places and thousands separators!  Many thanks.
  • Charlie
    Replied on July 11, 2017 at 4:48 AM

    Hi,

    May I know if you have checked the default "Text box" field/"Short Text Entry" field? 

    Form Builder: Add new field to handle currency formatting Image 1 Screenshot 50

     

    If you open the "Properties" of that field, you should be able to see the "Input Mask" option. 

    Form Builder: Add new field to handle currency formatting Image 2 Screenshot 61

     

    You can learn more about this option in this guide: https://www.jotform.com/help/381-Getting-Started-with-the-basics-of-Input-Masking

    For the decimal places, you can set it in the advance options when performing calculations using the Form Calculation widget or the Conditional logic. Below is an example, in the calculation wizard, if you clicked the "..." button, that will open additional settings.  

    Form Builder: Add new field to handle currency formatting Image 3 Screenshot 72

    The additional settings will allow you to use math functions or set up decimal places and it's separator.

    Form Builder: Add new field to handle currency formatting Image 4 Screenshot 83

     

    I'm also not sure how your inputs work. If the above option does not work, please let us know and we'll check if we have an existing solution for it. 

    I hope that helps. 

  • ROCGPerth
    Replied on July 27, 2017 at 12:53 PM

    Hi All

    I replied to this one by email some time ago but thought I would update it here also. This workaround still does not accomplish the desired result.

    We all need the ability to show non-calculated AND calculated values in the format #,###.00. This is the most basic currency format and it just cannot be accomplished.

    The above workaround achieves decimals and another workaround is to create a Text field, apply an input mask ##,###.00 and then deposit a conditional calculated total into it.

    However if you use the input mask ##,###.00 and the calculated total is less than 10000, the input mask inserts an additional zero to 'fill' the mask.

    If you use the input mask #,###.00 and the calculated value is 10000 or more, the incorrect total is shown as the input mask limits the total to the thousands column instead of the ten-thousands column. 

    Not having a currency field makes your amazing product that is superior to other form designers in nearly every way, quite frustrating because it feels like you cannot perform a very basic function ie. show dollars and cents in the correct format.

    I am pleading with you again, since I can see 'development' discussion and comment dating back to 2013, please can you add a currency field to the standard Form Elements list.

    Thanks for your time.

  • Chriistian Jotform Support
    Replied on July 27, 2017 at 2:52 PM

    Thank you for your suggestion. I would escalate this as a feature request to our developers. You will be informed once this is implemented.

    While it is not yet implemented, may I share to you a workaround I tried which is as follows:

    -------

    It will require you to add 2 fields, though.

    - Short Text entry field for input. 

    - Form Calculation widget which converts that input to currency format. Basically it uses the commaSeparate function

    Form Builder: Add new field to handle currency formatting Image 1 Screenshot 30

    -------

    You can see the output below.

    Form Builder: Add new field to handle currency formatting Image 2 Screenshot 41

     

  • ROCGPerth
    Replied on July 27, 2017 at 9:48 PM

    Thanks Chriistian. I will implement the above but if we could still have a standard currency form field added to JotForm's platform, that would be a massive help. The above solution is still duplication that shouldn't need to take place. Many thanks.

  • Ashwin JotForm Support
    Replied on July 28, 2017 at 12:54 AM

    Hello ROCGPerth,

    I understand. My colleague has already created a feature request ticket and forwarded it to our backend team. We will get back to you as soon as we have any update from them. 

    For now, I would suggest you to please take a look at our "Masked Input" widget and see if that fits into your requirement. It will not enforce you to fill fixed length.

    Thank you!

  • ROCGPerth
    Replied on July 28, 2017 at 1:02 AM

    Thanks Ashwin. Appreciate the further follow up.

    In regards to your Masked Input workaround - this will not work in this case as Masked Input fields do not work in a calculated field. ie. If you try to Masked Input 1 + Masked Input 2 = Calculated field, the result is blank. In fact even if you had Masked Input 1 + Number Field = Calculated field, it still won't calculate. I have mentioned this in a previous thread that has been separated from this one.

    Many thanks.

  • Nik_C
    Replied on July 28, 2017 at 3:02 AM

    Yes, you're right, the Masked input can not be included in calculations. The values are not showing.

    My colleague already forwarded this issue to our backend team, I will add a note as well.

    We'll inform you once we have more information about this feature implementation.

    Thank you!