How do I add commas & currency $ ?

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

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

Here's how:

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

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!!

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.

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)?

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.

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

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.

Here's how it works:

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.

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.

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