How to Convert 15-character Salesforce IDs to 18-character IDs

Add-on:

Classic Connector for Salesforce & Jira

Question:

Answer:

Create a Google Spreadsheet.
Go to Tools > Script editor...
Create a Blank Project

Copy and paste the code provided in the document into the editor

function SFConvert18(value) {
    if (value.length == 15){
        var convertedID = "";
        for (var i = 0; i < 3; i++){
            var baseTwo=0;
            for (var j = 0; j < 5; j++){
                var character = value.charAt(i*5+j);
                if(character >= "A" && character<="Z"){
                    baseTwo+=1<<j;
                }              
            }
            convertedID+="ABCDEFGHIJKLMNOPQRSTUVWXYZ012345".charAt(baseTwo);
        }
        return value + convertedID;
    }
    else{
        return "Error: Please enter a valid Salesforce ID with 15 characters";
    }
}
function SFConvert15(value){
    if (value.length == 18){
        return value.substring(0, 15);
    }
    else{
        return "Error: Please enter a valid Salesforce ID with 18 characters";
    }
}

Save and rename the project

How do I convert a 15-character Salesforce ID to an 18-character ID?

Type the function as in the following screenshot, then select the ID you want to convert. You may also select multiple IDs for conversion.

How do I convert an 18-character Salesforce ID to a 15-character ID?

Type the function as in the following screenshot, then select the ID you want to convert. You may also select multiple IDs for conversion.