Site Loader

Entities Forms Fields and Data Types:

Single Line Of text: This is used for small texts or string.

Open Set:  this type is use for drop-down control.  You can create local and global option set as per requirement.

Two Options: Two options set is basically used for true false, yes no type values. It’s Boolean data type.

Image: This type is mainly used to store logo image, you can use only one this kind of data type per entity which can maximum store 5120 kb data.

Whole Numbers: This field used for number in format like:

  1. None:  Set Minimum and Maximum value.
  2. Duration:  it’s used to store duration in terms of minutes, hours, days. Hours and days can be also entering using decimal like x.x.
  3. Time Zone:  it uses to store time zone of user.
  4. Language:  It’s dropdown value with different language to specify targeted entity language.

Floating point Number:  It uses to store floating point decimal numbers.

Decimal Number:  This is used for numbers with decimal value.

Currency: Uses to store money value.

Multiple line of text: This is used to store large text with maximum length of 1,048,576.

Date and Time: this is used to store date time data type.  It has following behavior –

  1. User Local: It stores user local time zone.
  2. Date Only: it stores only date part.
  3. Time Zone Independent:  It store data without any time zone conversion.

Lookup: This type is used to represent relationship from other entities.

Calculated Fields:  This is new feature in CRM which use to store data after calculation based on other attribute and conditions. Following data type is supported by this field:

  • Single line Text
  • Option Set
  • Single
  • Two Options
  • Whole number
  • Decimal number
  • Currency
  • Date and Time

When you select calculated field type, an edit button appears to put condition and action to perform calculation.

Rollup Fields:

Rollup field is used to perform automated calculation based on related entity record.  It supports following data type:

  • Whole number
  • Decimal number
  • Currency
  • Date and time

Same like calculation field you can find edit button which allows you to select source entity and then calculation condition.

Post Author: dynamics

Leave a Reply