Smartstaff, administrator
686
edits
Changes
no edit summary
__TOC__
Fields containing number values can be displayed in currency formats in other [[custom fields]] such as [[Custom Field Type: Display Only – Web Page View|Web Page View]] fields using the following syntax:
Therefore, a field named ''SampleField'' containing the value ''300'' can be displayed as follows:
{| border="1" cellpadding="4"
|'''Variable Used'''
|'''Value will be displayed as...'''
|-
|@format(SampleField,currency,USD)@
|$300.00
|-
|@format(SampleField,currency,EUR)@
|-
|@format(SampleField,currency,JPY)@
|¥300
|-
|@format(SampleField,currency,ZAR)@
|R 300.00
|-
|@format(SampleField,currency,INR)@
|₹300.00
|-
|@format(SampleField,currency,FRCA)@
|300,00 $
|}
<br />
By default, currency formatting will only be displayed when a record is in [[view mode]]. Currency formatting will be applied when the record is in [[edit mode]] only if the setting "Show Currency Format in Edit Mode" is selected in the custom field settings.
Example used within sslogic:
<pre>
<!--@sslogic("@type@"="Special")-->(minimum @FORMAT(Minimum Request Amount,currency,FRCA)@ CAD)<!--@end-->
</pre>
==XML data==
For [[Custom_Field_Type:_Special_-_XML_Data|XML Data]] node values you must place the syntax before the ''node.nodevalue''.
For example if the node is as follows:
<pre>@xml.SampleField.staff.subtotal.y1-amount.nodevalue@</pre>
To display as currency you should use:
<pre>@xml.SampleField.staff.subtotal.currency_eur(y1-amount.nodevalue)@</pre>
Therefore, a field named ''SampleField'' containing the value 300 can be displayed as follows:
{| border="1" cellpadding="4"
|'''Variable Used'''
|'''Value will be displayed as...'''
|-
|@xml.SampleField.staff.subtotal.currency_eur(y1-amount.nodevalue)@
|€300.00
|}
==See Also==* [[Category:VariablesNumber Format]] [[Category:CurrencyTo Move Later]]
