526
edits
Changes
no edit summary
*Sequential processing (i.e. on page load, each [[Custom Field Type: Special – Calculated Value|Calculated Value]] field is evaluated in order of their display order)
*Visibility (i.e. users can see the field and verify the default value before it is actually saved and stored into the field)
==[[Value Stores To]]==
*Synchronization (i.e. in the case that you have multiple fields that represent the same data set this can be used to synchronize the values between these fields)
*Transparency (i.e. works behind the scenes)
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 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).
*Server side validity (i.e. can be used for date/time functions to reference server time at exact time of saving)
*Complex calculations can be performed via MySQL syntax
*[[The Musings of Chin - SmartSimple's Order of Operations|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]]==
*Transparency (i.e. works behind the scenes)
[[Category:Chin’s Musings]] [[Category:Expert Tips and Tricks]]
