Does anyone have the Entry Mask or Reg Exp I would use to configure an attribute in Common Settings to only allow entry of whole numbers between 0 and 100?
Solved
Attribute for storing probability percentage
Best answer by jturcotte
One way to force this with Regex is:
\b(^[0-9]$|^[1-9][0-9]$|100)\b
This will only allow the numbers 0 - 100 and prevent negative values and decimal values.
Hello
I found this community article that might be helpful
Also a product idea that had been posted, encourage you to vote for it https://community.acumatica.com/ideas/need%2Dnumeric%2Dsupport%2Dfor%2Dattribute%2Dtype%2D3466
1 person likes this
Thank you
I’m familiar with using the # sign to limit user input to numeric values. But #,### doesn’t prevent users from entering numbers greater than 100.
One way to force this with Regex is:
\b(^[0-9]$|^[1-9][0-9]$|100)\b
This will only allow the numbers 0 - 100 and prevent negative values and decimal values.
1 person likes this
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.