0
edits
Changes
{{CustomFieldPageHeaderJavaScript Syntax}}'''General Description'''
==General Description==
Executes an expression to calculate a value and store the result.
{{FieldOptions}}
* '''Expression''': Defines the expression to be executed (additional details on Expression found in section below)
{{LabelAboveField}}
{{Searchable}}{{TrackChanges}}{{HideFieldToolTip}}
{{HideFieldForNewRecord}}
==Expression Field Details==
'''Expression''': Defines the expression to be executed
All values are treated as strings. For arithmetic operations, PARSEINT and PARSEFLOAT functions are used to convert the string value to a numeric value.
Example summing the values using five custom fields:
''ParseFloatssParseNum([Total Monthly Cost]) + ParseFloatssParseNum([Total Cost Ex]) + ParseFloatssParseNum([Hardware Rental]) + ParseFloatssParseNum([Email]) + ParseFloatssParseNum([Other])''
<pre>If you are using this field in a "Dynamic Control Field" address the fields by their field ids with the following syntax:
frm.cf_customfieldid.value
Example: PARSEFLOATssParseNum(frm.cf_1254625.value)*0.44
</pre>
You can use arithmetic, string, comparison operators and functions within the calculated [[Custom Field|custom field]]. * References to other fields are always enclosed in square brackets: [variable1] * The calculations are performed when you click the '''Save''' button and save the page.
* Calculated field formulas are executed in the same order that the calculated fields are displayed on the page.
* You must not place fields that perform summary calculations based on other calculated fields ABOVE the subordinate calculations.
** If the fields are ordered in this manner, saving the page will not update the summary calculation, as summary formula will be executed BEFORE the subordinate calculations are performed.
==SmartSimple Calculated Field Operators==
===Arithmetic Operators===
[[Image:CS08.png]]
'''Rounding''':
** To round a calculation to 2 decimal places use the following syntax::*** '''Math.round(('''''expression''''')*100)/100''''''Note:''' To round to a different decimal place just change '''*100)/100''' part as per requirement. Example:To round to 3 decimal places, you would use '''Math.round(('''''expression''''')*1000)/1000''' *** For no decimal places::**** '''Math.round('''''expression''''')'''
where ''expression'' is the calculation to be rounded off, such as PARSEINT([variable 1])/PARSEINT([variable 2])
===String Operators===
[[Image:CS081.png]]
===Comparison Operators===
[[Image:CS084.png]]
===Date Functions===
[[Image:CS085.png]]
'''calage([date of birth])''' - Calculates the number of full years between the current date and the date included in the function. '''calage([date of birth],1)''' - Calculates the number of years and months between the current date and the date included in the function as a floating point.'''calage([date of birth],2)''' - Calculates the number of years and months between the current date and the date included in the function as the string "X years and Y months".
===Time Functions===
To calculate the time difference for '''Standard Fields''' in hours and minutes use the following
Level 1:
**** ''timediff(frm.ostartdate.value,frm.oenddate.value,frm.ostarthour.value,frm.ostartminute.value,frm.oendhour.value,frm.oendminute.value)''
Level 2:
**** ''timediff(frm.startdate.value,frm.enddate.value,frm.starthour.value,frm.startminute.value,frm.endhour.value,frm.endminute.value)''
(note: the starttime and endtime '''Standard Fields''' are actually stored as part of the startdate and enddate fields, which is why they are used here)
===Other Functions===
To show the number of characters in a text field, use:
**** [''fieldname''].length
To show the number of words in a text field, use:
