Example:
X = custbody_datetoday (Date field)
Y = custbody_numofdaysprocessed (Free-Form Text field but has integer value)
Z = Custom Formula field (Free-Form text field)
X = 3/15/2011
Y = 4
Z = 3/19/2011
Below are the steps to create a custom formula field (Z).
1. Navigate to Customization > Lists, Records, & Fields > Transaction Body Fields > New
2. Provide the name of date field on Label.
3. Set the Type = Free-Form Text
4. Store Value = F
5. Under Applies To Tab, select Customer
6. Click the Validation & Defaulting Tab
Formula = T
Default Value = TO_CHAR({custbody_datetoday}+TO_NUMBER({custbody_numofdaysprocessed}),'mm/dd/yyyy')
7. Hit Save (or Save & Apply To Forms button)
* The formula may be applicable also on saved searches.
No comments:
Post a Comment