This example demonstrates validation and a few additional column types.

• The ID column is included as a display only column so it can be seen but not edited.
• The ICON column is read-only and displays the chosen Avatar and color as an icon. Any columns expressions that cannot be updated must have the Source: Query Only set to Yes.
• The Name column is set to Required. This will be checked on the client as well as the server. Required columns are indicated with a red triangle in the column header (when in edit mode). Remove the name (or leave it blank when adding a row) to see how the validation error is reported. Required is the only validation done on the client by default. See also Advanced Client Validation.
• This time the Hire Date uses an inline Date Picker. It is required. A validation is added to make sure it is in the past.
• A row validation is added so that the Commission must be less than 1.5 times the Salary.
• The PIN column is added to demonstrate the Password item type. This may not be commonly used in a grid but it is supported.
• The Avatar Color column demonstrates the Color Picker item type.
• The Tags column stores multiple values. It uses the Checkbox item type. You can try other types that work with multiple values such as List Manager, Shuttle, or Select List (multiple).

Interactive Grid gives you control over how columns are initialized when a new row is added or a row is duplicated. In this case the Name, Hire Date, and PIN are not copied. A default is chosen for Avatar and Color. Note that sorting etc. is disabled for the Icon and PIN columns.