Changes

Jump to: navigation, search

Custom Field Type: Special – Calculated Value

58 bytes added, 20:47, 19 February 2016
no edit summary
{{FieldOptions}}
'''Expression''': Defines the expression to be executed (additional details on Expression found in section below)
{{LabelAboveField}}
{{Searchable}}
{{TrackChanges}}
{{HideField}}
{{ToolTip}}
{{HideFieldForNewRecord}}
{{SmartFieldView}}
<u>'''Special Options for ==Expression Field'''</u>Details==
'''Expression''': Defines the expression to be executed
</pre>
'''{{OptionsTab}}{{Searchable}}{{TrackChanges}}{{HideField}}{{DisableFromGlobalSearch}} ==Formatting=={{FieldFormattingOptions}} ==Value Storage=={{ValueStoresTo}}  {{CFPermissionsTab}}   ==Notes''': == 
* You can in general use either the name of the field within square brackets, or frm.cf_''customfieldid''.value to refer to the values for the calculations.
* In both cases is that the field must be visible on the page (or a [[Hidden Value]] custom field that is on the page).
* [[Check Boxes]] cannot normally be used in Calculated Value fields. (They can be accommodated with sufficient knowledge of JavaScript)
{{VisibilityCondition}}
{{FieldPermissionMatrix}}
{{Services}}
{{ValueStoresTo}}
{{FieldFormattingOptions}}
{{FieldPermissions}}
'''Notes'''
You can use arithmetic, string, comparison operators and functions within the calculated [[Custom Field|custom field]].
* The calculations are performed when you click the '''Save''' button and save the page.
=='''Important Notes on Calculation Order'''==
* Calculated field formulas are executed in the same order that the calculated fields are displayed on the page.
* [''fieldname''].split(" ").length
===See Also===
* [[How Calculated Custom Fields Work]]
* [[ssParseNum]]
2,004
edits

Navigation menu