Thank you Alexander.

I added this javascript and while it does insert the commas correctly, it has impacted my other javascript that is calculating other fields and inserting the sums into a sub-total field.

When I enter 25,000 in one field, that is translated to 25 when it inserts that into the sub-total field.

Here is the javascript that is causing the issue. I am not sure what I need to change to get it to retain the complete value as entered:

When using parseFloat, you need to remove the commas. You'll also need to change the line where you save the value into the totaldebts field if you want the total to use commas. You can use something like

$(document).ready(function () {
  
  $('.commas input').attr("pattern", '^(\\d+|\\d{1,3}(,\\d{3})*)(\\.\\d{2})?$');
  
  $('.commas input').on("change", function () {
    $(this).val($(this).val().replace(/(\d)(?=(\d\d\d)+(?!\d))/g, "$1,"));
  });
  
  $('.sumdebt').on('blur', 'input', sumtotal);
  
  function sumtotal() {
    var s = 0;
    $('.sumdebt input').each(function () {
      s += parseNumber($(this).val().replace(/,/g,''));
    });
    $('.totaldebts input').val(s.toString().replace(/(\d)(?=(\d\d\d)+(?!\d))/g, "$1,"));
  }
  function parseNumber(n) {
    var f = parseFloat(n); //Convert to float number.
    return isNaN(f) ? 0 : f; //treat invalid input as 0;
  }
  
});

When I call the parseNumber function, I'm sending the value with the commas removed. Then after it does the summing, I convert the total value to a string and add the commas back.

Thanks again Alexander... that seems to have worked.

Only thing I noticed now is the commas don't get applied to any currency fields that happen to be in a repeating collection (other than the original field). If I select the link to add a new collection, then the currency field does not have the commas.

Also, the read-only sub total fields that I have where I am placing the result of all the calculations does not get the commas applied either. Not sure if that is because they are read only or something else.

Here is a screenshot of that section. You can see that there are no commas.

Thanks for your assistance. This is very helpful.

-Eric R

Thanks Alexander but when I use the code you provided above, it seems to break it entirely. That might be more me than you code though ;-)

I really appreciate your assistance but I am stuck on getting this to work correctly. Let me further state that I am not a developer so my knowledge of java script is quite limited.

I created a test form so I can play around with the code and I have most everything working correctly but the only things I can't get to work correctly is to have commas inserted in any of the fields that are in a repeating collection (other than the initial field) and to have the commas inserted in the total calculations at the bottom. Here is a screen shot of the test for I have set up that shows where the commas are being placed and where they are not. I have also attached the java script that I am currently using. I would appreciate your review and suggestions on what to change in my code to get this working correctly. The form is essentially a net worth calculator (I didn't include all the possible fields for this test form though). It adds up the persons assets and debts and then subtracts debts from assets to come up with a net worth value.

Here is the code I am using currently:

$(document).ready(function () {   
$('.commas input').attr("pattern", '^(\\d+|\\d{1,3}(,\\d{3})*)(\\.\\d{2})?$');
$('.commas input').on("change", function () {
$(this).val($(this).val().replace(/(\d)(?=(\d\d\d)+(?!\d))/g, "$1,"));
  });
});

$(document).ready(function () {
  $('.asset').on('blur', 'input', sumtotal);function sumtotal() {var s = 0;
  $('.asset input').each(function () {s += parseNumber($(this).val());
});
  $('.totalassets input').val(s);
}
function parseNumber(n) {
var f = parseFloat(n.replace(/,/g,'')); //Convert to float number.
return isNaN(f) ? 0 : f; //treat invalid input as 0;
}
});

$(document).ready(function () {
  $('.debt').on('blur', 'input', sumtotal);function sumtotal() {var s = 0;
  $('.debt input').each(function () {s += parseNumber($(this).val());
});
  $('.totaldebts input').val(s);
}
function parseNumber(n) {
var f = parseFloat(n.replace(/,/g,'')); //Convert to float number.
return isNaN(f) ? 0 : f; //treat invalid input as 0;
}
});

$(document).ready(function () { 
$('.asset input, .debt input').blur(function () {
$('.totalnetworth input').val($('.totalassets input').val() - $('.totaldebts input').val());
  });
});

Thanks again.

-Eric R

Thank you Alexander! Your code worked perfectly!!!