thousand separator with javascript on keyup event in crm

(0) Share

Report

Posted on by Community Member

hi,

i have a problem in crm , first i design form with decimal format but our value more than 100,000,000,000

and crm have validation in decimal number , and i force to use single line text field instead , and convert to decimal in my plugin and everything is ok , except one issue , in decimal field we have camma seprator for number by default when user input the number , i need a javascript code that do something like that , which dose not affect to save on field becuase i dont like run my plugin for lots of records that imported in crm , i just need to show seprator to text field when keyup on field or when form is loading , could you please help me , it's very force and i try with some jQuery code and i did not answer yet ,

i need something like this format in c# in ToString

ToString("#,##0.00")

but in Javascript in KeyUp Event and loading Time

thanks for your attention

*This post is locked for comments

I have the same question (0)

All responses (13)

Answers (4)

Suggested answer

RaviKashyap 55,410 Moderator on at

Like (1)

Report

Hi Somaye,

Try - toLocaleString('en')

=========

var num = "100000000";

alert(num);

alert(parseFloat(num).toLocaleString('en'));

========

stackoverflow.com/.../javascript-thousand-separator-string-format

Hope this helps.

Was this reply helpful? Yes No
Verified answer

gdas 50,091 Moderator on at

Like (1)

Report
Hi Somayeh,

You can also try with this -

var x= 1000000000008889; var y= x.toString().replace(/\B(?=(\d{3})+(?!\d))/g, ","); alert(y); // Y value will be =1,000,000,000,008,889

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

thanks for your reply

but i need some code like this , i dont want change text field value , i want only set seprator when type in text field

i try to add this jquery to crm but i could not do it ,

<html>

<head>

<script src="ajax.googleapis.com/.../jquery.min.js"></script>

<script>

(function Seprator($, undefined) {

"use strict";

// When ready.

$(function() {

// var $input = $( "#saba_taxamount2_i" );

var $input = $( "#amount2" );

$input.on( "keyup", function( event ) {

// When user select text in the document, also abort.

var selection = window.getSelection().toString();

if ( selection !== '' ) {

return;

}

// When the arrow keys are pressed, abort.

if ( $.inArray( event.keyCode, [38,40,37,39] ) !== -1 ) {

return;

}

var $this = $( this );

// Get the value.

var input = $this.val();

var input = input.replace(/[\D\s\._\-]+/g, "");

input = input ? parseInt( input, 10 ) : 0;

$this.val( function() {

return ( input === 0 ) ? "" : input.toLocaleString( "en-US" );

} );

} );

});

})(jQuery);

</script>

</head>

<body id="form2">

<input id="amount2" name="amount" type="text" maxlength="15" />

<div class="numbers2">2000000</div>

<div class="numbers2">5000000000</div>

</body>

</html>

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

thanks for your reply ,

i want some code that when i type in text field change it with seprator ,

i need keyup event in crm with javascript ?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

i dont like save value with comma seprator , i want only show with this format or when type number in text field

Was this reply helpful? Yes No
Verified answer

gdas 50,091 Moderator on at

Like (0)

Report
Hi Smayeh ,

You can do the same using onchange event of the field, as dynamics CRM does not support onkeyup functionality.

function OnChangeTextField() { var x = Xrm.Page.getAttribute("TextFieldName").getValue(); var y = x.toString().replace(/\B(?=(\d{3})+(?!\d))/g, ","); Xrm.Page.getAttribute("TextFieldName").setValue(y); }

Was this reply helpful? Yes No
Verified answer

RaviKashyap 55,410 Moderator on at

Like (0)

Report

Hi,

It would be difficult to achieve this using onkeyup as once the comma is added it would not be a number any more. You could try onchange just like crm does for decimal fields.

Was this reply helpful? Yes No
Verified answer

balakrishna uppala 570 on at

Like (0)

Report

Hi,

You can write code as Ravi/Goutam mentioned to set commas, but you can trigger that onFormLoad and OnChange functions.

In addition to that you can write a simple function to Remove Comma(,) from text and can trigger it OnSave event.(As you don't want to save Commas).

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

thanks all firends , all answer are true but ,because i import more than 10000 record in crm entity with out comma and run plugin on it , i like just show comma at on load or on change but i dont like save comma on those record ?

Was this reply helpful? Yes No
Suggested answer

RaviKashyap 55,410 Moderator on at

Like (0)

Report

Hi,

Thank you can write the code onchange event and amrk the field isdirty false. This way, the value will be shown with comma but because it is not dirty it wont be saved.

Hipe this helps.

Was this reply helpful? Yes No