Customer experience | Sales, Customer Insights,...

Remove comma from whole number field using Java Script, this whole number is incremented and update to primary key text field on other entity as record id

(0) Share

Report

Posted on by Sandy Hello

342

I have whole number field, which is created on Numbercreation entity which is incremented and updated for each record created on Service entity with the help of workflow proces, this whole number is updated on primary key text field on Service entity as record number. The problem here with whole number field is it is updated with comma on Service enitty e.g. " 600,000,001" in this format. How can I remove this comma on the whole number field for whole instance not for personal settings.

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Fubar 2,756 on at

Like (0)

Report

RE: Remove comma from whole number field using Java Script, this whole number is incremented and update to primary key text field on other entity as record id

For users that get added after the XrmToolbox fix suggested above, set the default format Settings->Administration->System Administration then the Formats tab.

However, making these settings is global, every form view etc, for all numbers and are you sure you want that (users usually complain that it is difficult to see what large numbers are particularly if there are lots of zeros and no separator)? I would just create a text field and copy the number into that field (stripping out non number characters) via plugin or workflow with a custom workflow activity.

Was this reply helpful? Yes No
Suggested answer

meelamri 13,216 User Group Leader on at

Like (0)

Report

RE: Remove comma from whole number field using Java Script, this whole number is incremented and update to primary key text field on other entity as record id

Hello,

You can change the individual personal settings for all the user with a tool named "User Settings Utility" available on XrmToolBox.

https://www.xrmtoolbox.com/plugins/MsCrmTools.UserSettingsUtility/

Next, you can change the security of your users to prevent them from changing their personal settings, Make sure that you give Read privilege as shown below:

Result:

Was this reply helpful? Yes No
Sandy Hello 342 on at

Like (0)

Report

RE: Remove comma from whole number field using Java Script, this whole number is incremented and update to primary key text field on other entity as record id

Thanks Vashti for your response, the above changes are valid for individual personal settings, i want the changes for whole instance

Was this reply helpful? Yes No
vashti hatami 40 on at

Like (0)

Report

RE: Remove comma from whole number field using Java Script, this whole number is incremented and update to primary key text field on other entity as record id

hi

go to administration -.> system setting ->

after that do according to pictures.

Was this reply helpful? Yes No