Add columns to a table

Add columns to a table and configure each column.

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	The 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	The data type for the column. The available options are: String (Default) Date Int16 Int32 Boolean Decimal
   Decimal precision	If the data type is Decimal, you can set the decimal precision. For example, if the decimal precision is set to 4, the numeric value displays decimal up to four places. (Default: 2)
   Currency code	If the data type is Decimal, you can set the currency code to be displayed at runtime. For example, if you select US Dollar, the $ (Dollar symbol) is displayed at runtime.
   Type	Display data in a table using any of the following controls: Text Drop-down Check Box Calendar Hyperlink Image Action List 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 that is 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 a 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 the 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".