Remove comma from a custom field created as an auto counter

(0) Share

Report

Posted on by Community Member

Greetings, I created a field (AutoNum) in the Leads entity and Workflows to increment by 1 when creating a new record. Works well - EXCEPT, the number carries comma (thousand separator). How do I remove that comma for this field only. Don't want to mess with other whole number fields in CRM. Thanks!

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (5)

Verified answer

Mithilesh Kumar 10,047 on at

Like (0)

Report

Hi Victor,

If you use Number field you will get that comma.

You can create a Text Field to store the value of number using Business Rule of JScript. Use this Text Field to show in Views.

This will also solve your problem of Searching using Quick Find as wild search for Number field does not work.

You can see this as well for Auto Number generation

https://arunpotti.wordpress.com/2014/03/21/auto-number-generation-using-real-time-workflow-in-ms-crm-2013/

Hope that helps

Thanks

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks for the quick response! Unfortunately, I'm not a JScript guy... any examples you could provide would be immensely appreciated!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Forgot to mention- used the realtime workflow per your link as well. Thanks again!

Was this reply helpful? Yes No
Verified answer

Mithilesh Kumar 10,047 on at

Like (0)

Report

Hi Victor,

You can follow this for reference.

community.dynamics.com/.../zero-code-development-quick-find-wild-card-search-on-whole-number-field-in-dynamics-crm-2015.aspx

Thanks

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

OK - I can try this - however, how to I remove the comma when the number is displayed in a form? Thanks again!

Was this reply helpful? Yes No
Verified answer

Mithilesh Kumar 10,047 on at

Like (0)

Report

Victor,

You need to hide the Number Field and Show the Text Field.

Thanks

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Got it - Thanks!

Was this reply helpful? Yes No
Verified answer

Mithilesh Kumar 10,047 on at

Like (0)

Report

Welcome !!

Was this reply helpful? Yes No
Verified answer

Mahadeo Matre 17,021 on at

Like (0)

Report

Hi Victor,

There is not supported option to remove comma unless you change format for whole organization..

if you want With unsupported way.. then try this

function FormatNumber()

{

var number= Xrm.Page.getAttribute("new_recordid").getValue();

document.getElementById("new_recordid").childNodes[1].childNodes[1].childNodes[0].nodeValue= number;

}

Call This function on your form load and change "new_recordid" with your attribute, and also make this attribute read-only..

because when focus is changed from this field CRM is formatting this attribute again with comma..

Hope This will help..

Was this reply helpful? Yes No
Suggested answer

triangular 162 on at

Like (0)

Report

Hi,

I tried the above solution and it works great.

Fyi I don't have to make the field read-only if users modifies it then it would not change back with the commas - I just have to enable the script on the OnChange event for that field.

Thanks.

-tri

Was this reply helpful? Yes No