Posts

Showing posts from 2014

Easy Maps for Account and Contact Addresses in Salesforce

Image
Some time ago, Salesforce had to remove their "Google Maps for Salesforce" from the App Exchange due to a change in Google's Licencing arrangements. I've not seen a good example of easy to use Google Maps in Salesforce since, so here are some Custom Field Formulas. Simply create a new Custom Field with a Forumla -> Text type, and copy/paste the below into the formula area. On the page layout, it works really well below the address entry areas. Each of these will display a static image map inline in Salesforce, and once the user clicks on the map, it will automatically display directions from the User's Address (stored on their User Profile) to that location. It will also complain to the user if they do not have an address on their profile, and will not display the Maps until they do. Account Billing Address if(or( $User.Street = "",  $User.City = "",  $User.Country  = ""),IMAGE("/img/samples/flag_red.gif", ...

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 ))

Cairns Webcams for Cyclone Ita

Here are some links for Webcams around Far North Queensland. I'll strike them out as they go down. Cairns http://www.cairnsinfo.com/webcam-cairns-city.php http://www.webcamgalore.com/EN/webcam/Australia/Cairns/5131.html http://www.skyrail.com.au/webcam/coralsea http://www.tmr.qld.gov.au/Traffic-cameras-by-location/Traffic-cameras.aspx?region=Far%20North http://www.earthcam.com/search/ft_search.php?term=Cairns%2C+AUSTRALIA http://www.justin.tv/gawdor Cooktown http://www.the-webcam-network.com/Australia/Cooktown/143686.html

Adding Google Search to Internet Explorer in Australia

Image
After I get my computer rebuilt at work, one of the first things I do is change the Search provider to Google in whatever archaic version of Internet Explorer we are still using. However, when I tried to do this today, Google was not in the list of Search Providers: After a moderate amount of cursing and nashing of teeth, I hacked the URL to point to the US page: http://www.iegallery.com/ en-us /addons?callback=true&featuretype=2 And you can reach the specific Google Search provider here: http://www.iegallery.com/en-us/Addons/Details/813