Changes

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]]

• ← Older edit
• Newer edit →

Alvin Thompson

2,004

edits