Cloudingo Quick Tip: The Elusive Salesforce 18 digit ID

Salesforce 15 vs 18 digit ID - cloudingo quick tips

Did you know that Salesforce IDs are actually comprised of 18 digits? The last 3 digits that aren’t traditionally seen within the Salesforce UI are a checksum of all the capitalizations of the first 15 characters, and was originally created as a workaround to legacy systems which were not compatible with case-sensitive IDs. Because there are applications like Microsoft Access which do not recognize that 00qf4000007zhir is a different ID from 00Qf4000007ZhIR, an 18-digit (00Qf4000007ZhIREA0), case-safe version of the ID is returned by all API calls. Neat huh?

Today, the 18 digit ID is referenced and used within the API, so be sure to know how to access it when the time comes.

Salesforce ID - Structure Explained. 15 vs 18 digits

How do I see the 18 digit Salesforce ID? To do this easily, you can place the CASESAFEID(Id) function in a formula field to capture the 18 digit id of a record and you’re set!

Leave us a comment below and let us know if this was helpful to you and please share this tip with your friends. Have a great weekend!

Share