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

Parents

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

Reply

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

Children

No Data