Setting column properties

This topic explains the procedure to set properties for table columns. In tree views, columns appear as levels. In cell-based tables, columns appear as cell fields.

To set column properties

1. Double-click the column heading, tree level, or cell field.
   In cell-based tables, only the top-left cell, called the working cell, is editable. Changes made to this cell are immediately replicated in the other visible cells. The working cell is not a separate or child field; it is an integral part of the cell-based table field.

2. On the Properties tab, set the following column properties:

   Property	Description
   Column Width	Specify the width of the column in pixels. See also the Auto Fit Columns property in Adding-a-table-field-to-a-form. The column size in a browser is not exact. The Mid Tier tries to fit columns into the specified table width. If a column's heading and data are narrow and its specified width is wide, the Mid Tier might shrink the column width to accommodate other columns so that all columns can be seen. Tree views do not use this property.
   Column Alignment	Horizontal alignment: By default, all numeric fields are right-aligned. All other fields are left-aligned. Vertical alignment: By default, all cells default to center vertical alignment.
   Display Type	List view, tree view, alert list, results list Select one of these options: Read Only—Users cannot change the field value. Editable—Users can change the value in column cells. Editing cells in a table does not affect data in the source form. On refresh or sort, changes that users make are lost, and the data displayed in the table is from the source form. Editing a table also does not affect the modify flag of the form, nor does it affect row colors. Tree views ignore this option. Read Only-HTML—Users cannot change the field value. In a browser, data in the cell is displayed as HTML. For example, if a cell contains <b>my cell</b>, it is displayed as my cell. Tree views ignore this option. If the column references a display-only field, you can specify the initial value of the column in the Initial Value field (see the following property). For more information about display-only fields, see the description of "Entry Mode" under Field-Properties. The following graphics show the examples of the Read Only and Read Only-HTML display types. In the Read Only-HTML type, the HTML tags get rendered to show the HTML formatting. Read Only: Read Only-HTML: Cell-based Display Type options match the options of the external field to which the cell field is linked.
   Hide Empty Column	(Nested Table) This property specifies if the column that contains no data is to be hidden. To enable this property, set the value for the Initial State property to Expandable. Select True to hide the column that contains no data or select False to show the column that contains no data.
   Hide Expand Column if Empty	(Nested Table) This property specifies if the expand option for the column is to be hidden when there is no data available in it. Select one of the following values: • True • False When you set the value for this property to True, the Expand option is hidden for the column that contains no data.
   Show as URL	(Table Column) This property specifies if the text in a column of a table is shown as a URL. Select True to show the text in a column as a URL or False to show the text in a column without a URL.
   Initial Value	(List view, tree view, cell-based, results list) For columns, levels, and cell fields that reference display-only fields, specify the initial value, which can have up to 255 bytes. If the column, level, or cell field has a display type of Editable or Read Only, its initial value can be either text or the value from another column in the same table. If the column, level, or cell field has a display type of Read Only-HTML, its initial value can be a combination of text and column references. If Default Value is a column reference, such as $Column2$, the value in the display-only column, level, or cell field is set to the corresponding value in that column. If the column reference is invalid, the reference is displayed as text. To specify an initial value, do one or both of the following, depending on the field's display type: Enter text into the Initial Value property's Value cell. Select the Initial Value property, click its ellipsis button, and use the Field Selector dialog box to specify column references. Alert lists do not use this property.
   Name	To change the column, level, or cell field database name, edit the value of this property. To change the column database ID (for example, to control the ID for purposes of shared workflow), you must change the ID after adding the column and before saving the table field. See Adding-a-table-field-to-a-form.
   Rows	(Nested Table Column) For a character field in a column of a nested table, this property specifies the the number of rows of text that are displayed. For the nested table, set the value for the Initial State property to Expanded, and then specify a value for this property.In a progressive view, the specified number of rows are displayed along with a Show more button. When you click Show more, full text is displayed along with a Show less button.
   Wrap Text	To wrap two or more lines of data in table column fields and to allow carriage returns in row data, set this property to True. This property does not apply to tree views.
   Vertical Button Alignment	(Table Column) This property specifies the vertical alignment of a button in a table column. To set the alignment of the button, select Top, Center, or Bottom. Double-click the column in a table to view this property on the Properties pane in Developer Studio.
   Horizontal Button Alignment	(Table Column) This property specifies the horizontal alignment of a button in a table column. To set the alignment of the button, select Left, Center, or Right. Double-click the column in a table to view this property on the Properties pane in Developer Studio.
   Visible	To hide the column, set the Visible property to False. See also Setting-sort-order-and-visible-levels.
   Render Data As Thumbnail	(Table Column) Specifies if the image in a column of a table is displayed as a thumbnail. Double-click the column in a table to view this property on the Properties pane in Developer Studio.
   Thumbnail Height	Specifies the height in pixels for a thumbnail. Enter an integer as a value for this property.
   Thumbnail Width	Specifies the width in pixels for a thumbnail. Enter an integer as a value for this property.
   Default Thumbnail Image	Specifies the default thumbnail image that is displayed in a table column. To add an image, click the ellipsis () button, and then select an image by using the Default Thumbnail Image dialog box.

3. For display-only fields, optionally specify a default value in the Default Value field. See Field-Properties.
   
   
4. (Cell-based only) If necessary, reconfigure the display properties of the working cell to accommodate the cell fields.
   For example, you can change the cell's width and height by dragging its borders.
   The working cell is part of the cell-based table field; it is not a separate field. When the working cell is selected, however, the Properties view shows only the table field properties that apply to the working cell.

5. To hide the table header or footer, right-click the table, and select Hide Header or Hide Footer.
   To redisplay the header or footer, right-click the table, and select Show Header or Show Footer.
   The default header and footer contain buttons and menus that enable users to perform table operations such as Refresh and Select All. If you hide the default header and footer, you can use the PERFORM-ACTION-TABLE commands to provide these table operations through custom controls. See Using-Run-Process-and-PROCESS-commands.

6. Set the remaining properties as necessary. See Field-Properties.
   
   
7. Right-click the form, and select Save.