8,849
edits
Changes
→Template Formula
==[[Template / Type Formula|Template Formula]]==
A way to update a field value behind the scenes. This is available in various areas and can be configured through the [[UTA]] settings page, [[:Category:Roles|User Roles]], or [[Client Categories|Company Categories]] pages. This setting is configured using MySQL syntax and works by directly updating the stored value of a field. This requires the user to save the form and [[The Musings of Chin - SmartSimple's Order of Operations|runs ]] after the form is saved, thereby referencing the latest field values that were saved.
===Advantages:===
*Ability to update different areas other than the form the user is directly on (i.e. a L2 formula can be used to update an L1 field)
*Sequential processing (i.e. saving an L3 results in L3 formulas, then L2 formulas, then L1 formulas to be run consecutively. Also within a template formula block, each individual line is processed consecutively thus allowing you to update a field value in one line, and then reference the new field value in the next line)
*Transparency (i.e. works behind the scenes)
==[[Workflow Task Types|Workflow Task]]: [[Update Custom Field Value|Update Custom Field]]==
