Skip Navigation
Expand
Values pasted into custom Integer fields change
Answer ID 7747   |   Last Review Date 12/18/2018

When I copy a number into an integer field the number changes to a value other than that which was entered

Environment:

Workspaces, Custom fields

Resolution:

If you find that the value displayed in your Integer custom field is different than the value you entered, review the configuration of the custom field to identify its minimum and maximum values. An Integer, or Whole Number, custom field will not display a numerical value that exceeds it maximum value, or is less than its minimum value.

As an example, if you have created a whole number field with a minimum value of 0 and a maximum value of 99,999,999 and an agent attempts to paste in the number 164109135, the field will display the maximum value of 99,999,999, which is a close as it can come to the value entered. Because the value pasted into the field exceeds the maximum value of the field it cannot be displayed.

The largest value allowed for an Integer field is 2,147,483,647. If you find that you are frequently in a position to enter numbers that exceed that value into your integer fields, as you might do when the number entered is a serial number or identification number, you may wish to consider utilizing a text field instead of the Integer/Whole Number data type.

Available Languages for this Answer:

Notify Me
The page will refresh upon submission. Any pending input will be lost.