Changes

Jump to: navigation, search

Template / Type Formula

20 bytes added, 18:03, 16 July 2013
General Information
Formulas can be defined in two different locations for each of the levels within the [[UTA]]
* The formulas on the [[UTA Settings - Entity|UTA Settings Page]] apply to all records saved at the specified Level.
* The formulas the [[Level 1 Templates|Template]] page (Level 1) or [[Level 2 Types|Type]] page (Levels 2 and 3) apply to records on the given Template/Type only.
If you wish to perform calculations on fields associated with Level 3, but store the results in fields at the Level 2, you use the '''Level 2 Formula''' field. You can use any expression and also some built -in functions. You may also wish to use Template Formulas instead of a Calculated field because the calculations are done server side, rather than by the browser.<br> Thus if you are doing a calculation on a value that needs to be populated or calculated on the same Level 3 item, this will avoid you having to save twice in order to get the final result. 
You may also wish to use Template Formulas instead of a Calculated field because the calculations are done server-side, rather than by the browser.<br>
Thus, if you are doing a calculation on a value that needs to be populated or calculated on the same Level 3 item, this will avoid you having to save twice in order to get the final result.
===Execution Sequence===
8,849
edits

Navigation menu