Add a Matrix Selector Control to a Form
Use the Form Editor (accessed from within a Blueprint in CSM Administrator) to add a Matrix Selector Control to a Form. When you add a Matrix Selector Control to a Form, you define:
- Validation instructions:
- Validation Table: Business Object that supplies all the possible values to the matrix (ex: Priority Matrix Element). Typically, this is a Lookup Object.
- Value Field: Lookup field (Field in the Lookup Object) that supplies the values (ex: Priority).
- Order By: Field to use to order the values in the matrix, as well as an ascending (ex: 0-10, A-Z) or descending (10-0, Z-A) order.
- Field to Populate: Field in the Business Object to populate with the final value from the matrix.
- Column properties: Values and order to display in the column header.
- Row properties: Values and order to display in the row.
- Constraints: Expressions that limit when the Field on the Form is populated with the final value from the matrix.
To add a Matrix Selector Control to a Form:
- Open a Form in the Form Editor.
- Drag-and-drop the Matrix Selector Control from the Special Control tree onto the Form.
- Right-click the
Control, and then select
Control Properties.
- Define the Validation:
- Validation Table/Field:
Select the Lookup table and Field that supply all the possible values (example: For Incident, it might be the Status field in the Incident Status Lookup table, with Status values like New, In Progress, Assigned, etc.).
- Order By:
Select the Field to use to order the values, as well as an ascending (ex: 0-10, A-Z) or descending (10-0, Z-A) order. Rarely will the alphabetical order match the order in which the values should appear in your item, unless you prefix the values with numbers or letters (example: For status, you would likely want lifecycle order, not alphabetical order); therefore, it is common to define a field that contains a sequence number purely for controlling the order (ex: Status Order).
- Field to Populate: Select the Field to populate with the final value from the matrix.
- Validation Table/Field:
- Define column properties:
- Column Header: Select the Field from the Lookup Object that supplies the value for the column header in the matrix.
- Save Column To: Select the Field in the primary Business Object to populate with the column value selected from the matrix.
- Define row properties:
- Row Header: Select the Field from the Lookup Object that supplies the value for the row header in the matrix.
- Save Row To: Select the Field in the primary Business Object to populate with the row value selected from the matrix.
- Define constraints that limit when the Field on the Form is populated
with the final value from the matrix:
- Click Add to add a constraint or filter.
- Select a Field in the Business Object you are currently working with.
- Select an operator (ex: Equals).
- Value: Select a value for the Field. Applicable values include:
- Click OK.
- Add additional constraints as necessary.
-
Click OK.
- After the Control or Controls are on the Form, use the Form Editor to define how each Control looks and behaves on the Form (ex: Size, image, alignment, anchoring, layering, visibility, and tab order).
- Publish the Blueprint (File>Publish Blueprint) to commit the changes, or save the Blueprint (File>Save Blueprint) to continue making other changes.