|
Home > eSalesTrack Help Menu > Administrator > Modules > Field Creator > eFormula > Formula - Text
eFormula
Text Formulas
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. Here
are some commonly used Formulas:
You can copy and paste these formulas into the formula
box. Drag and drop your text fields to replace "field". You can
also put numeric values in place of 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¦)
|
|
| |
There is
also the option |
|
|
|
|
|
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,#)
|
|
| |
LEFT(¦notes¦,25) field = a text area field. # =
the number of characters to display in the field. |
See also
| 
Page URL: