How to avoid 15-Digit ID woes in Salesforce Reporting

15-Digit ID, 18-Digit ID, Data Loader, Data Upload, Formula Field, Reporting
Have you ever received a report from a user that required a data load, yet the report had the 15-digit ID and not the 18?
A great way to empower the user to continue to pull the report and get you the 18-digit ID is to create a formula field and add it to the user’s report.
Here’s how to do it.

  1. Go to Setup | Object Manager | Object name | Fields & Relationships
  2. Click New.
  3. Click the Formula radio button and click Next.
  4. Click the Text radio button for ‘Formula Return Type.’
  5. Input the following formula into the Formula Editor:
  6. Set Field Visibility, add, or remove from the page layout.
  7. Click Save.
  8. Enjoy!
    Have any questions?
    Schedule an appointment: