Changes

Jump to: navigation, search

Custom Field Type: Special – Calculated Value

277 bytes added, 02:05, 7 October 2008
no edit summary
<u>=='''General Description'''</u> ==
Executes an expression to calculate a value and store the result. Additional information can be found in the [[SmartSimple]] wiki.
<u>=='''Field Options'''</u> ==
* '''Allow Empty''': N/A
* '''Store To Value''': N/A
<u>=='''Special Options for Field'''</u> ==
'''Expression''' – defines the expression to be executed.
''ParseFloat([Total Monthly Cost]) + ParseFloat([Total Cost Ex]) + ParseFloat([Hardware Rental]) + ParseFloat([Email]) + ParseFloat([Other])''
<u>=='''Field Validation'''</u> ==
* '''Type''': N/A
* '''HTML Tag''': N/A
<u>=='''Field Formatting Options'''</u> ==
* '''Height''': N/A '''Measure''': '''Default''':
* '''Tool Tip''': Yes
<u>=='''Notes'''</u> ==
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.
<u>=='''Important Notes on Calculation Order'''</u> ==  
* 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:Image:CS08.png]]
 
===String Operators===
 
[[Image:CS081.png]]
 
===Comparison Operators===
 
[[Image:Image:CS084.png]]
 
===Date Functions===
 
[[Image:Image:CS085.png]]
 
===Other Functions===
 
[[Image:Image:CS086.png]]
[[Category:Custom Fields]]
4,401
edits

Navigation menu