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:
@format(''FIELD NAME'',currency,''CURRENCYCODE'')@
where ''FIELD NAME'' is the name of the field being referenced
and ''CURRENCYCODE'' is the three-letter currency code used by [http://en.wikipedia.org/wiki/ISO_4217 ISO 4217]
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)@
|€300.00
|-
|@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 [[CategoryCustom_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:Variables{| border="1" cellpadding="4" |'''Variable Used''' |'''Value will be displayed as...''' |- |@xml.SampleField.staff.subtotal.currency_eur(y1-amount.nodevalue)@ |€300.00 |} ==See Also==* [[Number Format]] [[Category:CurrencyTo Move Later]]
