Details about this thread
  • State Not Answered
  • Replies 2 replies
  • Subscribers 309 subscribers
  • Views 1800 views
  • Users 0 members are here
Related content from around SugarClub

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

Jim Cotten

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

    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
Reply
  • 0

    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
Children
No Data