How do I add commas & currency $ ?

  • Profile Image
    freedomoftime
    Asked on February 23, 2021 at 04:29 PM

    Hi there.

    I'm not sure if my 1st submission went through or not. I need a bunch of these boxes to convert to currency showing the $ sign at the beginning once the formula computes and I also want it to show the commas in the dollar amounts.

    Please help show me how or just do it. The link is attached and a screenshot.


    Buddy Buck - freedomoftime@gmail.com

    USERNAME: freedomoftime

  • Profile Image
    Jed_C
    Answered on February 23, 2021 at 10:24 PM

    For the dollar sign, you can add the $ symbol in the form calculation settings.

    Here's how:

    1614136794_6035c5dac4bab_dollar sign.gif

    and for the comma, you can add the commaSeparate() formula. Please refer to my screencast below.

    1614137029_6035c6c5178b8_comma.gif

  • Profile Image
    freedomoftime
    Answered on February 24, 2021 at 02:15 AM

    Jed you are the man!!

    That is eXactly what I needed!


    Last thing...... How do I make $ and the commas in the field labeled: AVERAGE HOME PRICE.


    This one isn't one of the calculation widget ones... it's a standard field.


    THANKS IN ADVANCE!!

  • Profile Image
    Mike_G
    Answered on February 24, 2021 at 07:39 AM

    Based on my understanding of your form, respondents will enter a value in the AVERAGE HOME PRICE field. We would like to apologize for any inconvenience. I'm afraid that there is no option to automatically put a "dollar sign" or comma separator on the respondent's input on a form field. You can check the Input mask feature of a field, however, the input should always have the exact same number of characters for it to work.

    Reference Guide: Getting-started-with-the-basics-of-input-masking

    Also, calculated results or results inserted in another field using conditions or the Form Calculation widget can be comma-separated using the commaSeparate() Math function.

    Reference Guide: Math-function-reference: commaSeparate

    Feel free to let us know if you need any further assistance.

  • Profile Image
    freedomoftime
    Answered on February 24, 2021 at 10:43 AM

    There will always be 6 digits in the average home price field. Does that help?


    They might type: 450000 and I want it to automatically change to $450,000.


    Is that possible now that you know it will always be 6 characters (numbers)?

  • Profile Image
    Gaetan_B
    Answered on February 24, 2021 at 03:37 PM

    Hi,

    It can work, but not directly with the field itself.


    This transformation would have to take one field as an input, but it will have to output the result in a different field.

    It is not possible to do the transformation and to feed it back to the same field as it would create an infinite loop.


    Hope this helps.

    Do not hesitate to reach out if you need further assistance.

  • Profile Image
    freedomoftime
    Answered on February 24, 2021 at 05:01 PM

    Dang it.... I'm SOOOOOO close to having this work and look perfect. What other ideas do you have? What would you do?


    Thanks!!


    Buddy Buck

  • Profile Image
    Mike_G
    Answered on February 24, 2021 at 07:16 PM

    I would like to apologize for any inconvenience. There is actually a workaround that could meet your requirements since you mentioned that

    "There will always be 6 digits in the average home price field."

    The  AVERAGE HOME PRICE field is a Short Text field and you can enable its Input Mask feature to meet your requirements.

    1614211905_6036eb41aac6c_zt210224_191048

    Here's how it works:

    1614212047_6036ebcfa951c_zt210224_191256

    I just would like to add that, after you set up the Input Mask of the field, the field will require that you fulfill the input mask or it will give an error, as also shown in my screenshot above.

    Reference Guide: Getting-started-with-the-basics-of-input-masking

    Please give it a try and let us know if you need any further assistance.

  • Profile Image
    Mike_G
    Answered on February 24, 2021 at 07:19 PM

    Here is, by the way, the Input Mask I have used:

    $###,###

    And here's a cloned version of your form that I used in my screenshot above: https://form.jotform.com/210543260230944

    Feel free to let us know if you need any further assistance.

  • Profile Image
    freedomoftime
    Answered on February 24, 2021 at 08:12 PM

    Awesome, it worked!! We're done here. Thanks team.