Composite fields – Dynamics CRM 2013

Posted on

Microsoft Dynamics CRM 2013 introduces a new predefined field type for some system entities that is known as a composite field. You cannot modify the behavior of a composite field or add a new composite field. However, you can select whether to use a composite field in your forms or views.

A composite field concatenates the values of multiple text fields together as one text field in the database. You can add a composite field to a form as you would add any other field. The composite field is displayed on the form as a single control that shows the primary fields in a flyout when it is clicked. Many composite fields are already included on the forms for their entities.

For example, the Contact Full Name field appears on a form as a single field. However, when the user clicks the field, a flyout appears next to the field that asks the user for the First Name, Middle Name and Last Name fields separately. When these fields are completed, the user clicks Done and the completed field is displayed as a single control again. In another example, the Account Address 1 field can be displayed as a single field that will ask the user for seven separate fields from Street 1 through Country/Region when the user clicks the Address 1 field.

This approach uses much less space on a form than separate fields and can be easier to read as one item. You can add composite fields to views and forms.

If one or more of the fields that are used in a composite field is set to a field requirement level of Business Required, the composite field will be displayed as required on a record form (using a red asterisk to remind the user). This forces the user to provide a value for the composite field, and when the user clicks the composite field, the flyout will indicate the individual fields that are required.

Composite address fields always have a name with the suffix “_composite”, for example address1_composite or shipto_composite. The fullname composite field on Contact, Lead and User has no suffix in the field name.

Advertisements

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s