Add columns to a table

Add columns to a table and configure each column.

See Properties of a Table control

By default, two columns are added where data type=String, and control type=Text. You can edit these columns and add new columns. To add a column perform the following steps:

  1. In the Properties panel of the table control, click the Columns tab and click .

    The New column dialog box is displayed.

  2. Configure the following properties for a column.

    Name Description

    Display name

    Display name that appears as column header at runtime. For example, Customer name.

    Name

    Name to identify the column header during mapping.

    The name and display name can be the same.

    Align text

    Sets the alignment for the column text. (Default: left-aligned)

    Width (%)

    Width of the column based on the percentage value. (Default: 50)

    Enabled

    Enables the column for editing at runtime. (Default: Selected)

    Visible

    Makes the column visible at runtime. (Default: Selected)

    Data type

    Data type for the column. The available options are:

    • String (Default)
    • Date
    • Int16
    • Int32
    • Boolean
    • Decimal

    Type

    Display data in a table using any of the following controls:

    To display the data in a table at runtime, map the data to a table control using actions such as DB query, .NET Method or Redirect.

    Value when empty

    A default value to be used at runtime if the table column of control type text remains empty. If the text field value is empty at runtime, the system checks which property is selected at the design time. The value of a table column can be Null or Number. If Null is selected, the value of the text field when empty is null. If Number is selected, you can enter a numeric value (default: Number, 0) which is displayed at runtime. This applies to Desktop, Tablet and Mobile forms.

    The "Value when empty" property is only available for Int16, Int32 and Decimal data types for control type set to Text.

  3. Click Save.

    If you try to delete a table column which is used in any action, a message appears stating " This table column cannot be deleted as it is in use in a form action".