Share this page

# Example of using a table component on an order form

The following example shows the table component and rules functionality.

XYZ Corporation uses a request for creating and tracking employee computer hardware equipment orders. XYZ has included a table component field on their request type for gathering the order information. When the employee selects a product, the unit price is automatically updated. Then, when they update the quantity, the total line cost is automatically calculated and displayed in the table.

To enable this functionality, XYZ needs to configure the following:

1. Configure a new validation with the following specifications:

   Table 5-6. Example, table component validation settings
   Setting | Value / Description
   --- | ---
   Validation Name | Product Order Information
   Component Type | Table Component
   Column 1 | Column Header = Products Column Token = PRODUCTS Validation = Auto-complete with the following list values: PC, MOUSE, MONITOR, KEYBOARD
   Column 2 | Column Header = Quantity Column Token = QUANTITY Validation = Numeric Text Field
   Column 3 | Column Header = Price Column Token = PRICE Validation = Numeric Text Field
   Column 4 | Column Header = Total Column Token = TOTAL Validation = Numeric Text Field

2. Use the Rules tab to set the default unit price based on the product selected.

   Table 5-7. Example, Set Unit Price rule settings
   Setting | Value / Description
   --- | ---
   Rule Name | Set Unit Price
   Rule Event | Apply on Field Change
   Dependencies | Column = Products All Values = Yes
   Results | Column Header = Price
   SQL | `SELECT DECODE('[TE.P.PRODUCTS]', 'PC', 1200,` `'Mouse', 50,` `'Monitor', 560,` `'Keyboard', 110, 0),` `DECODE('[TE.P.PRODUCTS]', 'PC', 1200,` `'Mouse', 50,` `'Monitor', 560,` `'Keyboard', 110, 0)` `FROM sys.dual`

3. Add another rule to calculate and display the total line price in the Total column based on the values in the Products and Quantity fields.

   Table 5-8. Example, Calculate total rule settings
   Setting | Value / Description
   --- | ---
   Rule Name | Calculate Total
   Rule Event | Apply on Field Change
   Dependencies | Column = Price [All Values = Yes] Column = Quantity [All Values = Yes]
   Results | Column Header = Total
   SQL | `SELECT [TE.P.PRICE] * [TE.P.QUANTITY], [TE.P.PRICE] * [TE.P.QUANTITY]` `from sys.dual`

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: