Cooking Sama





Comments

Post a Comment

Popular posts from this blog

Salesforce Merge Accounts URL Hacking

The Merge Accounts page is OK to use, however to start the process you have to search for the Accounts you want to merge, and to do that they have to have the same name. This is not always the case, and it can be annoying to have to rename an account, just so you can find it to merge it. The official SFDC selection screen also limits you to a max of 3 accounts. This isn't actually a hard limit... More of a guide, as you'll see below. Instead of this, you can actually hack the URL to include the IDs of any accounts, regardless of Account Name similarity. This is especially useful if you are using your own code to manage merges and would like to "deep link" into the SFDC platform. Here's an example URL: https://emea.salesforce.com/merge/accmergewizard.jsp?goNext=+Next+&cid=001200000012345&cid=001200000012346&cid=001200000012347&cid=001200000012348 It can be broken down into 3 main segments: The Merge Accounts page URL: https://emea.sale...
Read more

Australian Postcode Boundaries for Google Earth (KMZ)

Image
I searched for ages, and couldn't find where to get a KMZ / KML file for Google Earth that had all the Australian Postcode Boundaries in it... So I made one based on the 1270.0.55.003 - Australian Statistical Geography Standard (ASGS): Volume 3 - Non ABS Structures, July 2011 . I claim no additional copyright on this, but please ensure you are able to use the data according to the ABS Copyright rules Here is the download link
Read more

Australian Business Number (ABN) Validation Rule for Salesforce.com

Assuming your Custom field is "ABN" (API Name = "ABN__c") then you can stuff this formula in a validation rule to ensure that ABNs entered are valid by using the same logic the government does . not(and (   LEN(TRIM( ABN__c )) == 11,   ISNUMBER(ABN__c),   mod(       (((VALUE(MID(ABN__c, 1, 1)) - 1 ) * 10) +  (VALUE(MID(ABN__c, 2, 1)) * 1) +  (VALUE(MID(ABN__c, 3, 1)) * 3) +  (VALUE(MID(ABN__c, 4, 1)) * 5) +  (VALUE(MID(ABN__c, 5, 1)) * 7) +  (VALUE(MID(ABN__c, 6, 1)) * 9) +  (VALUE(MID(ABN__c, 7, 1)) * 11) +  (VALUE(MID(ABN__c, 8, 1)) * 13) +  (VALUE(MID(ABN__c, 9, 1)) * 15) +  (VALUE(MID(ABN__c, 10, 1)) * 17) +  (VALUE(MID(ABN__c, 11, 1)) * 19)), 89   ) == 0 ))
Read more