0
edits
Changes
no edit summary
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 populate or calculated on the same Level 3 item, this will avoid you having to save twice in order to get the final result.
'''Template/Type Formulas are calculated when a record is saved.'''
When a Level 1 record is saved the formulas are executed in the following sequence:
* Level 1 General Formula-->Level 1 Template Formula
When a Level 2 record is saved the formulas are executed in the following sequence:
*Level 2 General Formula-->Level 2 Type Formula-->Level 1 General Formula-->Level 1 Template Formula
:* '''Note''': The Level 1 General and Template Formulas are only executed when a Level 2 is saved if they refer to a Level 2 variable.
When a Level 3 record is saved the formulas are executed in the following sequence:
* Level 3 General Formula-->Level 3 Type Formula-->Level 2 General Formula-->Level 2 Type Formula-->Level 1 General Formula-->Level 1 Template Formula
:* '''Note''': The Level 1 General and Template Formulas are only executed when a Level 1 is saved if they refer to a Level 2 variable.