Formula - Text
A Formula - Text field will allow you to create a formula and have the end result formatted as a text field. The end value must be text or the formula will not pull the information.
This guide will provide some commonly used formulas.
Note: You can copy and paste and one of these formulas into the formula box. Drag and drop your text fields to replace "field." You can aslso put numeric values in place of the fields.
- Combine Text
This will combine two text fields:
CONCATENATE(field,field)
- Combine Text with a Space
Calculates the result of a number raised to a power:
CONCATENATE(¦firstname¦," ",¦lastname¦)
- Facebook Search
This link will search facebook for the first and last name:
CONCATENATE("http://www.facebook.com/#!/search/o=2048&q=",¦firstnamex¦,"+",¦lastnamex¦)
- Linkedin Search
This will search linkedin for the values in the first and last name fields:
CONCATENATE("http://www.facebook.com/#!/search/o=2048&q=",¦firstnamex¦,"+",¦lastnamex¦)
- Google Map Search
This will search Google Maps for the values in the address, city, state, and zip fields.
CONCATENATE("http://maps.google.com/maps?f=q&source=s_q&hl=en&geocode=&q=",¦address¦," ",¦city¦,", ",¦state¦," ",¦zip¦)
- Google Search
This will search google for the value in the company name field.
CONCATENATE("http://www.google.com/search?sourceid=chrome&ie=UTF-8&q=",¦companyname¦)
- Wikipedia Search
This will search Wikipedia for the value in the company name field.
CONCATENATE("http://en.wikipedia.org/wiki/",¦companynamex¦)
- Ebay Search
This will summarize a text field and will return the specified # of characters from the beginning.
CONCATENATE("http://shop.ebay.com/?_from=R40&_trksid=p5197.m570.l1313&_nkw=",¦product¦)
- Summary of Text
This will search ebay for the value in a field.
LEFT(field,#)
field = a text area field. # = the number of characters to display in the field.
LEFT(¦notes¦,25)