Changes

Template / Type Formula

340 bytes added, 19:36, 5 June 2009
no edit summary
==Using Template/Type Formulas for Text==
If you are using a Template or Type formula to populate a field with '''text''', rather than perform a calculation, you must enclose the statement on the right-side of the equal sign in single quotations.* Any other textinside the quotation marks, including spaces, will be concatenated to the resultwith the variables:
:
@opportunity.name@='"@opportunity.client first name@ @opportunity.client last name@'";
::''Note that the space between the "client first name" and "client last name" variables will place a space between them in the resultant statement.''
'''Example 2'''
@opportunity.name@='"@opportunity.item 1@, @opportunity.item 2@ and @opportunity.item 3@'";
::''Would result in a comma and space between the first 2 items and the word "and" between item 2 and 3.''
 
''You can use single quotes instead of double quotes, but if there is a single quote mark stored within one of the variables it will stop the concatenation of the string. Similarly using double quotes will provide incorrect results if one of the variables stores text that includes a double quote.''
[[Category:Universal Tracking Application]]
0
edits