Customization and Configuration

{Common Data Service} Timezone, Language, Duration and Ticker Symbol Field Format

I have been asked to Create dropdown which will list down all timezones in Dynamics CRM. Earlier I was thinking to go with HTML web resource then I came to know the field format.

The following table lists the format string values to expect for each type of attribute schema type and format option.

Application Field TypeFormat OptionAttribute TypeFormat Value
Date and TimeDate Onlydatetimedate
Date and TimeDate and Timedatetimedatetime
Whole NumberDurationintegerduration
Single Line of TextE-mailstringemail
Whole NumberLanguageoptionsetlanguage
Whole NumberNoneintegernone
Single Line of TextText Areastringtextarea
Single Line of TextTextstringtext
Single Line of TextTicker Symbolstringtickersymbol
Single Line of TextPhonestringphone
Whole NumberTime Zoneoptionsettimezone
Single Line of TextUrlstringurl

In this blog I will walk you through Timezone, Language, Duration and Ticker Symbol Field Format.

Navigate to Entity->Field->Create New->Select field Type and format.

I have added all fields on the Account form.

As you can see you get nice dropdown fields for Language Duration and Timezone.

Language will list down all language which are enabled for your CRM Instance.

Now when you fetch these fields value in Web API, this is what it looks like

{@odata.context:"https://powerappsinfylearn.crm8.dynamics.com/api/data/v9.0/$metadata#accounts(new_duration,new_language,new_tickersymbol,new_timezone)/$entity",
@odata.etag:"W/"4030905"",
new_duration@OData.Community.Display.V1.FormattedValue:"90",
new_duration:90,
new_language@OData.Community.Display.V1.FormattedValue:"1,033",
new_language:1033,
new_tickersymbol:"MSFT",
new_timezone@OData.Community.Display.V1.FormattedValue:"190",
new_timezone:190,
statecode@OData.Community.Display.V1.FormattedValue:"Active",
statecode:0,
accountid:"bc0732bb-9c04-eb11-a813-000d3af020c4",
merged@OData.Community.Display.V1.FormattedValue:"No",
merged:false
}

For Duration, Timezone and Language you get Integer value associated to the options.

Ticker Symbol – A ticker symbol is an arrangement of characters—usually, letters—representing particular securities listed or traded publicly. When a company issues securities to the public marketplace, it selects an available ticker symbol for its shares. Investors and traders use the ticker symbol to place trade orders

You will see Stock market bar symbol besides field data and when you click on the link it will open Stock exchage page.

Hope this helps!

One thought on “{Common Data Service} Timezone, Language, Duration and Ticker Symbol Field Format

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s