Difference between revisions of "Category Formula"
From SmartWiki
(Created page with 'A Category Formula is analogous to a Template / Type Formula, though it performs advanced calculations and logic on custom fields stored on the Organization profile, for Orga…') |
|||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 4: | Line 4: | ||
An example Category Formula would be: | An example Category Formula would be: | ||
| − | <nowiki>@ | + | <nowiki>@grandtotalpoints@=@trans.sum(#12345#):typename='whatever'@</nowiki> |
| − | *In this example, ''' | + | *In this example, '''grandtotalpoints''' is the custom field we are storing the sum in. |
| − | *The sum is of all [[transactions]] on the | + | *The sum is of all [[transactions]] on the organization's record of custom field id number 12345 given a particular transaction type name ("whatever"). |
| − | *The custom field named ''' | + | *The custom field named '''grandtotalpoints''' will be updated on the profile of organizations who possess this Category every time the Organization profile page is saved. |
==See Also== | ==See Also== | ||
| Line 14: | Line 14: | ||
* [[Custom Field ID|Determining the Custom Field ID]] | * [[Custom Field ID|Determining the Custom Field ID]] | ||
| − | [[Category: | + | [[Category:Field Update Formulas]][[Category:Roles]] |
Latest revision as of 14:01, 23 October 2017
A Category Formula is analogous to a Template / Type Formula, though it performs advanced calculations and logic on custom fields stored on the Organization profile, for Organizations possessing this Category.
The Category Formula is entered on the Edit Category page and will only be applicable for organizations which possess this Category.
An example Category Formula would be:
@grandtotalpoints@=@trans.sum(#12345#):typename='whatever'@
- In this example, grandtotalpoints is the custom field we are storing the sum in.
- The sum is of all transactions on the organization's record of custom field id number 12345 given a particular transaction type name ("whatever").
- The custom field named grandtotalpoints will be updated on the profile of organizations who possess this Category every time the Organization profile page is saved.
