Examples of Formula and Combination Fields
Display |
Custom field |
Result in custom field |
|---|---|---|
Number of days since the item was received. (Formula field) |
DateValue (Now())-DateValue ([Received]) & " Day(s)" |
6 Day(s) |
Description of a meeting or appointment in Calendar. (Formula field) |
"This meeting occurs " & [Recurrence Pattern] & " in " & [Location] |
The meeting occurs every day from 12:00 P.M. to 1:30 P.M. in room 1231 |
Amount to be charged for a phone call recorded in the Journal at $0.75 a minute. (Formula field) |
IIF ([Entry Type] = "Phone call" , Format ([Duration] * .75, "Currency"), "None") |
$1.50 |
Description of a Message Flag. (Formula field) |
IIF ( [Flag Status] = "2", [Message Flag] & " " & [Due By],"") |
Follow up 3/5/2009 8:00:00 A.M. |
The first phone number recorded for a contact, in order of appearance in the formula. (Combination field) |
[Business Phone] [Business Phone 2] [Home Phone] [Home Phone 2] [Cell Phone] |
(555) 555-1234 |
A description of a field combined with the field itself. (Combination field) |
Task Due: [Due Date] |
Task Due: 3/5/2009 8:00:00 A.M. |