To convert it to 18 digits you can simply set it to an id type variable: Click the text radio button for 'formula return type.' 5. Go to setup | customize | object name | click fields. The formula to convert salesforce ids (which you might have already encountered in the functions list) is. Except that salesforce doesn't export the 18 digit version when you include the record id in standard exports. Salesforce has a build in formula for you to use: Then, you can match ref<<strong>salesforce id</strong>> with the regex. The last 3 digits of it are the checksum of the capitalization of the first 15 characters. The last 3 digits of a salesforce id 18 are a checksum of the first 15 characters. Copy/paste your ids, urls, etc.
Navigate to the user's profile. The apis (a programmable call to get information) always return eighteen digit record id. Copy/paste your ids, urls, etc. Click the formula radio button. Salesforce ids are 15 or 18 characters of base 62 data. As for the external id field not showing up in dataloader, ensure that the fls for the field is such that you have edit access to the field The last 3 digits of it are the checksum of the capitalization of the first 15 characters. Casesafeid(id) set field visibility at field level and also add/remove it on page layout. Click the text radio button for 'formula return type.' 5. In the related list custom fields & relationships click new. Select the object of your choosing.
