Procedure for Adding a Column to a Table

Open the needed table:

1. Select Object > Find.

   The Find Objects dialog box opens.

2. Select Table from the Object pull-down list.
3. Enter the name of the needed table. You can use the * wildcard.
4. Click Find.
5. Click the needed table to select it, then select Object > Open > Edit.

   The Edit Table dialog box opens.

Click Add.

The Add Column dialog box opens showing the Expression tab.

On the Expression tab:

1. Click the ellipsis button for the Expression field. The Select Pattern dialog box opens.
2. Click the Attribute check box and click Filter.
3. Select the needed attribute.
4. Click OK.
5. Select the Business Objects option button.

Enter basic details:

1. Click the Basics tab.
2. Enter the Name for the column as a string resource key using this format:

   Note: If a string resource has already been created for this attribute, such as when adding a field to a form, you can reuse that string resource instead of creating a new one.

   emxAPPNAME.STRINGID

   where:
   

   • APPNAME is the product name
   • STRINGID is the identifying name used to map the name of this field to an entry in the string resources file

   For example, if you want the name to show as "Thickness" in English, on a page titled "Create Custom Part" in Engineering Central, you would enter the name using this format:

   emxEngineeringCentral.CreateCustomPart.Thickness

   Add a line to the emxAPPLICATION_NAMEStringResources.properties file in this format:

   emxAPPNAME.STRINGID=STRING_VALUE

   where:
   

   • APPNAME is the product name
   • STRINGID is the identifying name used to map the name of this field to an entry in the string resources file
   • STRING_VALUE is the English text to display

   In our example, you would enter:

   emxEngineeringCentral.CreateCustomPart.Thickness="Thickness"

   See Internationalizing Business Process Services Products for details on adding this string resource to properties files for other languages.

3. Enter a Description for the field.

Enter link details:

If the cells in the column will not be clickable by the end user, skip this step.

1. Click the Link tab.
2. Enter the Href, the URL for the page that opens when the user clicks a cell in the column
3. Enter the Alt text that displays when the user hovers the mouse over the column

Enter settings for the column:

1. Click the Settings tab.
2. For each setting, enter the Name and Value, then click Set. See Settings for Table Column Objects for details about the available settings.

   Typical settings that should be defined include (see Table Columns):
   

   • Registered Suite. The application the column belongs to.
   • format. How the data in the column should be displayed.
   • Input Type. For edit mode, how the user enters data.
   • Access Expression, Access Function, Access Mask, Access Program. Define who has access to the column.
   • Editable. For edit mode, defines if the user can edit the cell value.

Define who has access to the column:

If you want this column accessible to all users who have access to the table, skip this step.

1. Click the Access tab.

   Avoid adding specific users. Typically, use this tab to grant access based on a person's role to the field.

2. Click Add.
3. Select the needed role. You can use the Name box and Filter button to search for the needed roles.
4. Click OK.
5. Click User [All] then click Remove.

Click OK to save and close the Add Column dialog box.

In the Edit Table dialog box, place the field where you want it to appear in the form by clicking the field, then clicking Move Left or Move Right until it shows in the needed location.

Click Edit to save the table.