Type
The Type column on a container field defines the variable that the input field represents in the database. There are three main types of values you can put in this field: system types, such as System.String; category types, which represent a sort of picklist; container types, which represent a link to another page or table if it’s a one to many relationships.
System Types
Most fields have a type value representing the C# type and database type backing the field. The value should be the name of a C# type appropriate for the ControlType, such as System.String for a Text control or System.Decimal for a NumberFormatting control.
List of supported types:
| Integers | Real numbers | Other |
|---|---|---|
System.Int16 |
System.Single |
System.String |
System.Int32 |
System.Double |
System.Boolean |
System.Int64 |
System.Decimal |
System.DateTimeOffset |
Category Types
For Category and Radio controls, the Type is not a C# type but rather a Category defined elsewhere in the Excel sheet; these will look like Form.<Name> where <Name> is the name of another Excel sheet (or column in the Categories sheet). To allow selection of multiple values, enclose the type in [] brackets (e.g. [Form.Name]).
Reference Types
For Link, Page, Reference, and Table controls, the Type represents another Container sheet; these will look like Form.<Name> where <Name> is the name of another Excel sheet. For Table controls, enclose the type in [] brackets (e.g. [Form.Name]) to represent the fact that a table stores many values.
Controls
The Type column applies to, and is required for, the following controls: