You need to sign in to do that
Don't have an account?
Brian Naidu
How to I display the last 6 digits of a 15 digit number? (without removing the other digits)
Hello,
I'm new to Salesforce. In our assest records we have part numbers that range from 15-25 digits. These numbers are entered into fields in SF for documentation. The last 6 digits of the 15-25 number is the actual serial number of the part, the rest is manufacturing codes. I would like the field to display the last 6 digital, but if a user click (or double clicks) the field it shows the full lenght number.
If you have a solution that would be great and how to create it. I inherited the Saleforce and trying to figure it all out.
Thanks for any help!
Brian
I'm new to Salesforce. In our assest records we have part numbers that range from 15-25 digits. These numbers are entered into fields in SF for documentation. The last 6 digits of the 15-25 number is the actual serial number of the part, the rest is manufacturing codes. I would like the field to display the last 6 digital, but if a user click (or double clicks) the field it shows the full lenght number.
If you have a solution that would be great and how to create it. I inherited the Saleforce and trying to figure it all out.
Thanks for any help!
Brian
One thing you could do is create a text formula field to display the last 6 digits of that field. This way you will have 2 fields, one showing the serial number and another showing the entire number including the manufacturing codes.
Where name_of_your_field__c is the name of your 15-25 digit field.
Hope that helps!
All Answers
One thing you could do is create a text formula field to display the last 6 digits of that field. This way you will have 2 fields, one showing the serial number and another showing the entire number including the manufacturing codes.
Where name_of_your_field__c is the name of your 15-25 digit field.
Hope that helps!