Siebel Interactive Designer Administration Guide > Advanced Modeling for Interactive Designer > Trigger and Target Feature Tables for Interactive Designer Applications >

Example of Creating Trigger and Target Tables


In this example, you add Trigger and Target Feature tables that populate a drop-down list with appropriate year values, based on whether a user wants to purchase a new or used car.

At runtime, if users of the Interactive Designer application select New for Class of Car, they have one option in the Car Year drop-down list.

Click for full size image

If users select Used, they can choose from a list of year values.

Click for full size image

Creating the YEAR Target Table

Creating the YEAR target table requires three steps:

  • Creating a target table named YEAR.
  • Creating row types for the target table.
  • Populating the target table with values.

Each of these steps is explained in the following procedures.

To create the YEAR target table

  1. In the Pagesets screen, select the Feature Tables tab.
  2. Choose New Record from the applet menu.

    A new Feature Table window appears.

  3. Enter a name, without spaces, for the Feature table.
  4. From the Table Type drop-down list, select Target.
  5. Click Save.

To create the row types for the YEAR Target table

  1. In the Feature Tables tab, select the YEAR Target table.
  2. Select the Editor tab.
  3. In the Editor, click New.

    A new row appears in the editor.

  4. Click the Row Type picklist icon to open the Feature Table Rowset picklist.
  5. Click New.

    The New Rowset dialog appears.

  6. In the Name text box, enter YEAR_NEW.
  7. Click Save.
  8. Repeat this procedure and create a second new rowset named YEAR_USED.

To populate the YEAR target table

  1. In the Feature table editor, create a row with values for the YEAR_NEW rowset.
  2. In the Feature table editor, create a row with values for the YEAR_USED rowset.

Creating the CLASS Trigger Table

Use the following procedure to create the CLASS Trigger Table.

To create the CLASS Trigger Table

  1. In the Pagesets screen, select the Feature Tables tab.
  2. From the Feature Table applet menu, choose New Record.

    A new Feature Table window appears.

  3. In the Name text box, enter CLASS.

    From the Type drop-down list, select Trigger.

  4. Click Save.
  5. Select the Designer tab.
  6. From the applet menu, choose New Record.
  7. In the Column Name text box, enter YEAR.

    In the Designer tab, the Target Table button is enabled.

  8. Click the Target Table button to open the Target Table picklist.
  9. Select the YEAR target table and click OK.
  10. Follow the steps in To enter data in the feature table.

    NOTE:  In the column tied to the Target table, you can only enter row types.

Creating UI Controls to Display the Trigger and Target Values

Use the following procedure to create UI controls to display the Trigger and Target values.

To tie the Trigger and Target Feature tables to UI controls

  1. In the Input UI tab, click New.
  2. Enter values in the new row.
  3. Click Save.
  4. Click New again.
  5. Enter the following values for the second row.
  6. Click Save.
Siebel Interactive Designer Administration Guide