Attributes are linked to form controls according to their data type. The table below provides a list of form controls and the compatible data types that can be used with them.
Control | Data Type |
---|---|
Checkbox | Bit |
Comment | Unique Identifier (in case of communication with a second entity) |
Date/Time Picker | Date, DateTime, DateTime2 |
File Attachment | NVarChar (size: 100, according to the number of attachable files), NVarChar_Max, VarChar, VarChar_Max |
Free Draw | VarBinary, VarBinary_Max. |
Gantt Chart | Unique Identifier (in case of communication with a second entity) |
Grid | Unique Identifier. It can be used to bind different fields together. The data type may or may not be same for each field in the list. |
Nested Form Link | Unique Identifier (in case of communication with a second entity) |
Numeric Textbox | Big Int, Decimal, Float, Int, Money, Numeric, Small Int, Small Money, Tiny Int. |
Radio-Button List | String Data Types (such as Char, NChar, NText, NVarChar, or Text), Numeric Data Types (such as Decimal, Float, Int, Numeric, or Real) , and the Bit (Boolean) data type. |
Textbox (Single-Line, Multi-Line, Password) / Rich Textbox | Char (Char or NChar), VarChar (VarChar or VarChar_Max), NVarChar (NVarChar or NVarChar_Max). |
Time Duration | DateTime |
Tree | Unique Identifier (in case of communication with a second entity) |
User Picture | VarChar (size: 36, in the case of communication with the MercUsers entity) |
User Signature | VarChar (size: 36, in the case of communication with the MercUsers entity) |