Configure table component

This section provides details on how to configure table component.

Table component use example

Table component can be used to store multiple records in a single field on a request. You can configure table component to include multiple columns of varied data types. You can also configure rules for populating elements within the table and enabling functionality for capturing column totals.

For example, XYZ Corporation creates a request type for collecting quotes and parts for hardware. Each request of this request type collects the following information:

  • Products

  • Quantity

  • Price

  • Total

To collect the information, XYZ creates a table component field labeled Hardware Information.

When a user logs a request for new hardware, the request displays the Hardware Information field. After the user selects a product in the Hardware Information field, the Price and Total columns are automatically populated. When the request is submitted, it contains all the information required to order the hardware.

Back to top

Configure table component

You can add table component field type to request types only. The table component field type is supported on the following pages: the Create New Request page, the Request Details page, and the request look-ahead page.

To create a table component field for a request type:

  1. Create a new or open an existing validation, see Configure validations.

  2. From the Component Type list, select Table Component.

  3. Provide a validation name and description.

  4. In the User Instruction field, provide any user instructions to display at the top of the table entry page.

  5. To enable users to import table component from Excel, select the Enable Import from Excel check box. For details, see Import data from Excel to the table.

  6. On the Table Columns tab, click New to create table columns.

  7. In the Field window, define the type of information stored in that column. This may require you to create a validation for the column.

    Field

    Description

    Column Header

    Provide a name for the column.

    Column Token

    Provide the token syntax for the column. For a list of all explicit entity format tokens, see Tokens.

    Each column in the table component has an associated token. You can use these tokens in the same manner as other field tokens, such as for commands, notifications, or advanced field defaulting. For detailed information about referencing tokens related to table components, see Use tokens.

    Description

    Provide a description of the data stored in the column.

    Enabled

    Choose Yes to enable the column.

    Validation

    Click the auto-complete button to select an existing validation for the column.

    The following validations are supported for the table component:

    • Text field

    • Drop-down list

    • Radio buttons (yes/no)

    • Auto-complete list

    • Text area

    • Date field (short, medium, and long)

    • Web Address (URL)

    • Password field

    • Link

    • Attachment (Available in 24.2 and later versions)

    New

    Opens the Validation window to define a new validation for the column.

    Component Type

    Displays the component type associated with the validation.

    Multi-Select Enabled

    Whether the options are enabled or not depends on the validation and component type.

    Choose Yes to allow users to select multiple values for the column field, or choose No to restrict users to select only one value.

    Attributes tab

    Click the Attributes tab and configure the following:

    • Editable. Choose Yes to allow users to edit the column, or choose No to make the column read-only.
    • Display Total. Enabled only when the field's validation is a number. Choose Yes to display the column total at the table bottom, choose No to not display column total. For details on calculating column totals, see Example of calculating column totals.
    • Required. Choose Always to make the column field required, or choose Never to make it optional.

    Default tab

    Click the Default tab and configure the following:

    • Default Type. Choose Constant to display a default value for the column, or choose None to not display a default value.
    • Visible Value. Enabled only when you select Constant for the Default Type field. Specify the default value for the column.

    Storage tab

    Click the Storage tab and configure the following:

    Max Length. Specify the maximum length of the column.

    Parameter Col. Select a parameter for the column.

  8. To copy an existing column to the table, click Copy From and then select a column.

  9. Click OK to add the column information or click Add to add the column and continue to add another one.

  10. When you add all the columns, click Save.

Back to top

Configure rules in table component

You can set up rules for table component to enable advanced defaulting behavior or calculating column totals.

Considerations for configuring rules

  • You can use SQL rules and UI rules in table component, in the same way you use them on request level.
  • You can configure columns in the table to default to certain values based on an event or value in another column in the table. The following rule events are supported in table component: Apply on creation and Apply on field change.

Configure rules in table components

To configure rules in table components:

  1. Follow the instructions in Configure table component .

  2. In the Validation workbench, click the Rules tab. You can either create a new rule or copy from an existing one.

  3. To create a new rule:

    1. Click New.

    2. In the Rules Window, complete the following fields:

      Field

      Description

      Rule Name

      Provide a name for the rule.

      Description

      Provide a description of the rule.

      Enabled?

      Choose Yes to enable the rule.

      Rule Event

      Select an event for the rule.

      Process subsequent rules?

      Specify whether subsequent rules are processed after this rule is completed.

      Dependencies

      Use the New, Edit, and Remove buttons to define column dependencies.

      For example:

      Column = Price [All Values = Yes]

      Column = Quantity [All Values = Yes]

      Results

      Select the results columns.

      For example: Column Header = Total

      Logic

      Define the logic associated with the rule. Can be SQL Default or UI Rules.

      For example, the SQL could be:

      SELECT [TE.P.PRICE] * [TE.P.QUANTITY], [TE.P.PRICE] * [TE.P.QUANTITY]

      FROM sys.dual

      For information on how to work with UI Rules, see the Demand Management User Guide.

      For detailed examples, see Example of using a table component on an order form.

    3. Click OK to add the rule or Add to add the rule and continue adding a new one.

  4. To copy a rule from an existing one:

    1. Click Copy from.

    2. In the Validation field, select a validation from which you want to copy the rule and then click OK.

      All the rules of the selected validation are loaded in the Copy Rules window.

    3. Select the target rule and then click OK.

  5. Click OK or Save.

Back to top

See also: