Can I format a Number field into Currency?

  • Profile Image
    rondadew
    Asked on March 05, 2017 at 11:15 AM

    I am trying to calculate amount owed and I think I've figure out how to use the logic, but I would like the "answer" to be in dollars.  I can't seem to figure out how to do that?

     

  • Profile Image
    Jim_R
    Answered on March 05, 2017 at 01:33 PM

    If you're referring to the actual Number Field, then no, there's no way to add anything on that field except numbers.

    However, if you're doing calculations, either with the Form Calculation Widget or the UPDATE/CALCULATE FIELD Condition, then just manually type in the currency before the number.

    In case we misunderstood your question, just get back to us with a bit more info and the form' you're working with so we can better assist you.

    Related guides:

    How-to-Perform-Form-Calculation-Using-a-Widget

    How-to-Manipulate-Text-String-with-Conditions-and-Calculation 

  • Profile Image
    ROCGPerth
    Answered on June 14, 2017 at 12:25 PM

    I have seen requests going back 3 years asking for a currency field. I don't understand what could possibly be stopping you from introducing a currency field but with all the other AMAZING things Jotform can do, this is a real big missing feature. The input mask is great for its purpose but as soon as you use it, you can longer use the field as a calculated value. There must be many, many users that use Jotform for membership forms, quotes, room bookings etc, all of which would require some form of calculated total value in a currency format. Could we please please please have a currency field made available in the very near future. Many many thanks!

  • Profile Image
    david
    Answered on June 14, 2017 at 01:41 PM

    The setup recommended in this thread does exactly what you are looking for.  You can append a currency symbol to the beginning of a calculated value without it affecting the calculation.  No need to use input mask.