Open Account Shipping Addresses in Google Maps With Formula Fields (Salesforce Essentials Edition)

Follow these steps to create a custom formula field on the Opportunity object that generates a clickable hyperlink to open the Account's shipping address in Google Maps.

Create Custom Formula Field

1. Click the gear icon on the top right corner of the Salesforce screen
2. Select Setup
3. Click Object Manager
4. Select Opportunity
5. Click Fields & Relationships
6. Click New
7. Select Formula then click Next
8. Provide the field with a name, like Google Address as an example
9. Select Text as the Formula Return Type then click Next
10. Click the Advanced Formula tab
11. Copy then paste the formula below into the blank section on the screen
    • HYPERLINK("https://www.google.com/maps?language=en_US&q="+ Account.ShippingStreet +","+Account.ShippingCity+","+Account.ShippingState+","+ Account.ShippingPostalCode , " "+Account.ShippingStreet+"," &BR() +Account.ShippingCity +"," &BR() +Account.ShippingState +"," &BR() +Account.ShippingPostalCode )
    • The above formula is using the Shipping address field values from the Opportunity's associated Account to build a url. Your users are then able to click the generated hyperlink for the url which will open the address in their Google Maps application. If you use the Account Billing address fields instead of the Shipping fields, simply replace the fields in the formula above with the Billing address fields.
12. Click Next
13. Click Next
14. Click Save

For more information, check out our tips for working with hyperlink formula fields!