Difference between revisions of "Role Formula"
From SmartWiki
| Line 2: | Line 2: | ||
An example Role Formula would be: | An example Role Formula would be: | ||
| − | <nowiki>@totalpoints@=@trans.sum(#1224#+#23445#):typename='whatever'@</nowiki> | + | <nowiki>@totalpoints@=@trans.sum(#1224#+#23445#):typename='whatever'@</nowiki> |
In this example, '''totalpoints''' is the custom field we are storing the sum in. | In this example, '''totalpoints''' is the custom field we are storing the sum in. | ||
Revision as of 14:03, 3 October 2013
A Role Formula is analogous to a Template / Type Formula, though it performs advanced calculations and logic on custom fields stored on the Contact profile, for Contacts possessing this role.
An example Role Formula would be:
@totalpoints@=@trans.sum(#1224#+#23445#):typename='whatever'@
In this example, totalpoints is the custom field we are storing the sum in. The sum is of all transactions on the user's record of custom field id numbers 1224 and 23445 given a particular transaction type name ("whatever").
