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...
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...
If you are using a spreadsheet, you're likely using the Excel connector also? In which case, the installation of the connector includes a function called fixid() that will convert to 18 digits.
ReplyDeleteMostly people Export the report in the excel, so if we have the 18 digit id as a field to report on, then this field will be readily available.
ReplyDeleteGreat that its through a simple formula field.
ReplyDeleteHelpful information on Salesforce, thanks a lot for sharing.
ReplyDeleteSalesforce Consulting Services