| contentAdfStringified | {"type":"doc","version":1,"content":[{"type":"table","content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Add-on:","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"short-text","parameters":{"id":"an4qjxreh9","extensionKey":"short-text","name":"content:space","placeholder":"","isRequired":false,"type":"line","atlassian-macro-output-type":"INLINE"}}}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Question:","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"short-text","parameters":{"id":"juzjohvf9m","extensionKey":"short-text","name":"page:title","placeholder":"","isRequired":false,"type":"line","atlassian-macro-output-type":"INLINE"}}}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Answer:","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"paragraph","parameters":{"id":"zn8w4007x6","extensionKey":"paragraph","name":"kbAnswer","isRequired":false,"Type":"area","atlassian-macro-output-type":"BLOCK"},"layout":"default"}}]}]}]}]} |
|---|
| fieldGroupName | migrated |
|---|
| fieldGroupId | 9iaapc2fpe |
|---|
| excerpt | Add-on: Classic Connector for Salesforce & Jira Question: How to Convert 15-character Salesforce IDs to 18-character IDs 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. |
|---|
| propertyKeys | ["net.customware.confluence.plugin.scaffolding__9iaapc2fpe__data_0_fqnmppx6mn"] |
|---|
|