This is a cool little text link to locate the Account using one of two different mapping websites and the Account Billing Address. All with a single click!
- Setup | Build | Customize | Accounts | Buttons, Links, and Actions | New Button or Link
- Name: Map this Account
- Display Type: Detail Page Link (creates a text link)
- Behavior: Display in new window (opens in a new browser tab)
- Content Source: URL
- Copy & paste code below for desired website
- Click Save
- Add to page layouts: Setup | Build | Customize | Accounts | Page Layouts | Edit (the appropriate pages)
- Click Custom Links
- Drag and drop Map this Account to the Custom Links section of the page
- Click Save
Code for Google Maps:
Code for MapQuest:
If currency field Contracted Sales Volume_c is blank, AND
picklist field Time Period_c = Initial, Renewal, Extension, or Open Ended – Terms
Require: Contracted Sales Volume_c
ISBlank(Contracted_Sales_Volume__c)&& OR( ISPICKVAL( Time_Period__c , “Initial”) ,ISPICKVAL(Time_Period__c , “Renewal”),ISPICKVAL(Time_Period__c , “Extension”),ISPICKVAL(Time_Period__c , “Open Ended – Terms”))
My client utilizes contracts and some of those contracts allow for renewals and those renewals can vary in length. We needed to be able to calculate the ultimate expiration date for all contracts.
Requirement: Determine the Ultimate Contract Expiration Date
The math: Contract End Date multiplied by Renewals Allowed_c multiplied by Length of Each Renewal_c
Formula Return Type: Date
EndDate + ((Renewals_Allowed__c * Length_of_Each_Renewal__c) * (365.25 / 12))
Thank you, SteveMo!
If Arrangement Type_c equals ‘Contract’
Calculate a Re-Bid Date_c which is the Ultimate Expiration Date_c minus Owner Expiration Notice.
Here’s the formula that worked:
IF( ISPICKVAL(Arrangement_Type__c, ‘Contract’) , Ultimate_Expiration_Date__c – CASE(OwnerExpirationNotice,”15 Days”, 15,
“30 Days”, 30,
“45 Days”, 45,
“60 Days”, 60,
“90 Days”, 90,
“120 Days”, 120,Null) , Null)
If you’d like to see how I ended up here and the conversation posted on Answers, visit http://bit.ly/1d2Eq5A
Much thanks to Jeff May, Damien Owen, and Andrew Johnson for taking the time and providing the guidance/solution.