Table properties in Table Builder

Various table and table column properties can be modified by using Table Builder.

Table column properties

The following table shows descriptions of the properties that you can modify for the columns in a data table.

Tableau 1. Table column properties

Field	Description
Column label	Unique label for the column.
Column name	Database name for the column.
Type	Type of information that the column contains. For example, to contain plain text in the column, select String. Depending on the type that you select, fill in the additional fields to further define the table column. For example, if you select String, define the character limit of the string input. Or, if you select Choice, define the choices that users can choose from. See Field types.
Reference	Table that is associated with the column. This field applies only if the column type is Reference.
Max length	Maximum number of characters that users can enter in the field.
Default value	Value that populates the field automatically after a new record is created.
Display	Option to set the column as the display value for the table. A reference field shows the display value of the table to which it is referring. For example, the Opened by column of the task table refers to the user table. Because the display value of the user table is the user name, the Opened by field shows something like Beth Anglin or Joe Employee. When you select a display value, choose the table column that would act as an appropriate title for individual records. Only one column can act as the display value for a table.

Table properties

The following table shows the descriptions of the properties that you can modify for a selected data table.

Tableau 2. Table properties

Option	Procedure
Change the table label	In the General information tab, update the Table label field.
Make the table extensible	In the General information tab, select Advanced. Select the Make extensible check box.
Add record numbers	In the General information tab, select Advanced. Select the Add record number check box. Define the record numbers by updating the Prefix, Starting number, and Number of digits fields.
Accessible from	Open the Access tab. In the Accessible From field, select All Application Scopes or This Application Scope Only.
Application access controls	Open the Access tab. In the Application Access Controls field, select Read, Create, Update, and/or Delete selection boxes to specify the desired level of access for the table.