Sample Account Media Service Formulas

Formulas to link to specific search sites and media accounts.

Available in: both Salesforce Classic and Lightning Experience

Available in: All Editions

For details about using the functions included in these samples, see Formula Operators and Functions by Context.

BBC™ News Search

This formula creates a link to a BBC news search site based on the Account Name.

1HYPERLINK(
2"http://www.bbc.co.uk/search/news/?q="&Name, 
3"BBC News")

This formula creates a link to an account's ticker symbol on the Bloomberg website.

1HYPERLINK(
2"http://www.bloomberg.com/markets/symbolsearch?query="&TickerSymbol, 
3"Bloomberg News")

This formula creates a link to a CNN news search site using the Account Name.

1HYPERLINK(
2"http://http://www.cnn.com/search/?query="&Name,
3"CNN News")

This formula creates a link to an account's ticker symbol on the Marketwatch.com website.

1HYPERLINK(
2"http://www.marketwatch.com/investing/stock/"&TickerSymbol,
3"Marketwatch")

This formula creates a link to a Google search site using the Account Name.

1HYPERLINK(
2"http://www.google.com/#q="&Name, 
3"Google")

This formula creates a link to a Google news search site using the Account Name.

1HYPERLINK(
2"http://news.google.com/news/search?en&q="&Name, 
3"Google News")

This formula creates a link to a Yahoo! search site using the Account Name.

1HYPERLINK(
2"http://search.yahoo.com/search?p="&Name, 
3"Yahoo Search")

This formula creates a link to a Yahoo! news search site using the Account Name.

1HYPERLINK(
2"http://news.search.yahoo.com/search/news?p="&Name, 
3"Yahoo News")