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:
- None: Set Minimum and Maximum value.
- 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.
- Time Zone: it uses to store time zone of user.
- 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 –
- User Local: It stores user local time zone.
- Date Only: it stores only date part.
- 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.