• About
  • Contact me!

Salesforce Everywhere

~ Blog on Salesforce Dev and admin stuff

Salesforce Everywhere

Tag Archives: 15to18 character Id

Tip#9: CASESAFEID and Converting 15 Character Salesforce Id to 18 Character Id

22 Tuesday Sep 2015

Posted by Mani in Salesforce Configuration

≈ Leave a comment

Tags

15to18 character Id, CASESAFEID

Salesforce has 2 versions of Id, 15 and 18 characters. Originally, all Salesforce IDs were 15-characters and case-sensitive whereas 18 character Id is case insensitive.

Suppose, we are exporting report data from salesforce onto excel and using the Excel VLOOKUP function to match up records. Since VLOOKUP doesn’t handle case-sensitive data well, we would have to convert 15 character Salesforce Id to 18 character Id.

As part of Spring ’12 release, Salesforce introduced a new formula function CASESAFEID, which accepts a 15-character ID as a parameter and returns the 18-character version. For instance, CASESAFEID(Id).

Also, I use the link https://www.adminbooster.com/tool/15to18 to convert 15 character Id to 18 character Id instantly.

There is a knowledge article on converting 15 to 18 character Id and the link for the same is https://help.salesforce.com/apex/HTViewSolution?id=000005288&language=en_US

Advertisement

Blog Stats

  • 114,773 hits

Archives

Recent Posts: Salesforce Everywhere

How to get field values on onLoad in lightning-record-edit-form in LWC?

Using Dynamic Actions

How to check if the logged in user is a Guest user or not in APEX class?

How to Close Quick action in LWC

Lightning component to filter Products and display results in lightning data table

Connect with me

  • View @manibalan_s’s profile on Twitter
  • LinkedIn

Developer links

  • Salesforce Developer website
  • Salesforce Success Community

Enter your email address and click on Follow us (below) to follow this blog and receive notifications of new posts by email.

Website Powered by WordPress.com.

  • Follow Following
    • Salesforce Everywhere
    • Already have a WordPress.com account? Log in now.
    • Salesforce Everywhere
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar