Is there a way to force the display of a leading zero in an integer field?

As an example, the salesforce has an id which is a three digit number but may have leading zeros so that when 028 is entered, 28 is what is displayed. I want to display 028 instead. this can affect sorting and alignment when reports are exported.

Thanks in advance,

JimC

0 André Lopes over 4 years ago

It depends of real field's type.
If a given field has type 'varchar' but it usually stores an integer field, then it will be interpreted as a varchar on ordering, that means, '1000' is lower than '9'.
So you REALLY want to manage a field as a real integer one then you must create it as well, otherwise you should turn it into an integer field.
Regards

André Lopes
Lampada Global

Skype: andre.lampada
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Rolustech Support over 4 years ago

Hello Jim,
You will need to convert your field from integer to a varchar field. This will, however, affect the sorting on this list view. Otherwise, you can write some custom JS to store the field as a varchar and display as varchar but sort based on an integer value.
Kind Regards,
Rolustech Support
Email: support@rolustech.com
Website: www.rolustech.com
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel