Showing posts with label id conversion. Show all posts
Showing posts with label id conversion. Show all posts

2 April 2014

Salesforce: How to Convert 15 digit Id to 18 Digit Id

How to Convert 15 digit Id to 18 Digit Id

It's common scenario where we need to convert 15 Digit Case Sensitive Salesforce Record Id to 18 Digit Case insensitive Id. 
It's necessary to have 18 digit Case insensitive Id when it comes to VLOOKUP in Excel sheet for various purposes.

It's possible to convert 15 digit Id to 18 digit Id without any Code.

Trick:

1. Go to Object-> fields
2.Create a new field of field type "Formula".
3.Put formula:  CASESAFEID( Id )




4. Go to the Page layout and put this field on the page layout.


Try this Trick and let me know your feedback...