Microsoft Dynamics CRM (Archived)

Trying to Create a 6 Digit Numeric Field without Decimals or Commas

(1) Share

Report

Posted on by CRM Learner 88

Is there any way I can create a field in CRM where it's maximum 6 digits but does not insert a comma?

I've tried with whole number with minimum value 0 and maximum 999999 but it always inserts a comma..

*This post is locked for comments

I have the same question (0)

All responses (12)

Answers (2)

Suggested answer

Aric Levin - MVP 30,190 Moderator on at

Like (0)

Report

Numeric fields will always have a comma by default, but you can change that in your regional settings.

Go to System -> Administration -> System Settings.

In System Settings, click on the Formats tab, and then click on the Customize button.

In the Number tab on the Customize Regional Options, in the Digit Group, select the option that has no commas (shown below).

That should be it. Good luck.

Was this reply helpful? Yes No
CRM Learner 88 on at

Like (0)

Report

Could I have it be with both no commas and no decimals? Basically this is an ID Number field where we want it to be all numeric.

Was this reply helpful? Yes No
Aric Levin - MVP 30,190 Moderator on at

Like (0)

Report

Not really. You need some sort of separator between them.

The options are period, command or backslash.

So you could have 123456789/123456

If you need only numbers in this format, I would you a string field.

Was this reply helpful? Yes No
CRM Learner 88 on at

Like (0)

Report

So if I want a field that must be 6 numeric digits and don't want a comma or decimal to be accepted, what should I do? Is a string field part of configuration or is this getting into coding?

Thanks for your help I really appreciate it.

Was this reply helpful? Yes No
Suggested answer

Friyank 944 on at

Like (0)

Report

you can use string type and use JavaScript function to validate input value

var value = Xrm.Page.getAttribute("new_customnumerice").getValue();

var regex = /^[0-9]{1,6}$/;

if( !regex.test(value ) ) {

alert('false')

}

Was this reply helpful? Yes No
Aric Levin - MVP 30,190 Moderator on at

Like (0)

Report

If the value is only 6 digits, you can use a whole number and make the changes the I specified above, but you have to consider that these changes are across the board, meaning, they will change it for all entities.

I think your best bet is to you a string and set it to six characters. You can control the string using JavaScript that will only accept numeric values.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

Hi,

You can handle this with javascript. Follow these steps :

1. Open up the form, where you want to apply this.

2. Edit the form and Click Form Properties.

3. Click on Events tab and Select the event on which you want to run it.

4. On Event Handlers Section, Click on Add button to add Function Name to be called on the selected Event.

5. then, Click on Edit Library button and Paste Your Javascript Code to validate value in the tetbox.

6. Click OK.

7. Click Save and Publish.

Please mark my answer as verified, if it solves your query.

Thanks.

Was this reply helpful? Yes No
CRM Learner 88 on at

Like (0)

Report

I've never written code before, is this something easy I can do within CRM or is visual studio needed?

Was this reply helpful? Yes No
Suggested answer

prt33k 6,907 on at

Like (0)

Report

You can go to Setting-administration->system Setting-> format and choose 'blank space' as Digit Group. This will make the comma go away however do note that this will get applied to all integer field.

Ideally, a string should be used for ID since user also ask to have number with leading zeros etc in which case the numeric option will not fly.

Thanks,

Prateek

Was this reply helpful? Yes No
CRM Learner 88 on at

Like (0)

Report

Thank you for providing these steps! It looks like we already have an "onLoad" function on this form. When I click 'Add' there is a Library already populated in the field and it seems to use the same code as what is in there originally.

Should I just delete the code that is there and paste in the new one? Or should I paste this code into the existing one we have already at the bottom past what is already there?

Was this reply helpful? Yes No