Posted on 11. June 2013

Number Formats in User Settings

If you need to localise numeric in a CRM Client Side User interface, you'll need to query the UserSettings and use the following properties:

Field

Description

NumberSeparator

The character used to separate number groups for readability as defined by the NumberGroupFormat property detailed below.

E.g. if the NumberSeparator=',' then the number would be formatted:

123,456,789

DecimalSymbol

The character used to separate the decimal part of the number.

E.g. if the DecimalSymbol='.' Then the number would be formatted:

123.456

NumberGroupFormat

Defines the grouping of digits for readability:

 

Value

Result

3

123,456,789.00

3,0

123456,789.00

3,2

12,34,56,789.00

0    

123456789.00

 

NegativeFormatCode

Defines how negative numbers of formatted:

Value

Result

1

-1234567

0

(1234567)

2

- 1234567

3

1234567-

4

1234567 -

CurrencyDisplayOption
(Organization Settings)
Defines how the Currency will be displayed:

Value

Result

0

Currency Symbol (e.g. $12345.00)

1

Currency Code (e.g. USD 12345.00)

 

@ScottDurow

Posted on 5. June 2013

Rockstar365 Interview

Last week I was very honoured to be asked to take part in an interview with Rockstar365. I'd like to thank Paul for making me feel right at home!

You can watch my interview here: http://blog.rockstar365.com/2013/06/01/meet-scott-1-in-the-uk-on-rockstar-365/

See my complete profile here - http://rockstar365.com/ScottDurow