Customer experience | Sales, Customer Insights,...

How to restrict user in entering decimal values for a whole number field without rounding off

(1) Share

Report

Posted on by Sneha Aitha

Hello All,

I am working on Dynamics 365 v9 onpremise. I need a number field which accepts only numbers without any decimals / float number. For this, I have created a field with data type "Whole number", the issue we identified is when I enter "11.6", the system is rounding off the number and getting displayed as 12. I want to restrict the user in entering the decimal numbers.
I have tried to register onchange event for this field to restrict the user in entering decimals, but unfortunately the function is getting triggered after the value getting round-off.
Could anyone suggest on how to restrict a whole number field in entering only digits from 0 to 9,

Many Thanks in Advance!

All responses (2)

Answers (0)

Community Member on at

Like (0)

Report

RE: How to restrict user in entering decimal values for a whole number field without rounding off

Hi Partner,

Has the problem been solved? Any updates?

Please click Yes under "Did this answer your question?" to close this thread.

Thanks.

Regards,

Leah Ju

Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.
Suggested answer

Community Member on at

Like (0)

Report
RE: How to restrict user in entering decimal values for a whole number field without rounding off

Hi Sneha,

There is no straightforward way to enter number without rounding off, but you can create two fields and use Math.trunc() function to achieve it.

Here are steps.

1.create two fields. (one is whole number data type, another is decimal number data type)

If you need, you can set whole number filed is read-only.

2.Js code.

function setNumber(executionContext) { var formContext = executionContext.getFormContext(); var oriNumber = formContext.getAttribute("new_testnum").getValue(); var number=Math.trunc(oriNumber); if(oriNumber!=null) { Xrm.Page.getAttribute("new_testnumber").setValue(number); } }

Add the JS code as web resource to OnChange event.

3.Test

When I fill ‘testnum’ field with value ’11.6’, the ‘testnumber’ field will be filled with ‘11’.

Regards,

Leah Ju

Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.