Show/Hide Toolbars

PerfectApps ® Help Guide

You can select a column in one of two ways:

 

With the Table object selected, in the columns section of the Properties panel double-click on the header cell of the row that describes the table column you want to select.

In the Table object within the layout area, click in the header area of the column.

 

Properties

Properties vary according to the data type of the selected column.

 

Settings: Name - This is the column name and is the equivalent of the field name for normal field objects.

Settings: Header - This is the text that appears in the column header.

Settings: Width - This is the width (in pixels) of the column. This can also be changed by dragging the cell divider within the header area of the table.

Settings: Footer Row - (Applies to Numeric Input and Text Input column types only) Select Sum or Average to populate the footer row of this column with that value. Note that the option to show footer must also be selected in the table properties.

Settings: Mandatory - Makes the object mandatory in order to submit the app instance. You may enter a custom message in the box to display if the object has not been populated. Click the Universal - Ellipses Button button to load the Mandatory dialog. Use this matrix to make the object mandatory based on conditions of roles and stages.

flag_green

You can make all the columns within a Table object the same width by loading the Table properties in the Properties panel and clicking the fit columns evenly Universal - Fit Columns Evenly Button button.

Data Type Specific - Depending on which column data type you selected, you will also be able to change further properties. These properties behave in the same way as the corresponding standard objects such as Date Input, Text Input, and Button.

Access: State - This represents the field state for the object (default, normal, read-only, disabled, hidden). Click the Overview Ellipses Button button to the right of the State drop-down to load the Edit State dialog. Use this matrix to dynamically set the object state based on conditions of roles and stages.

Document Icon

To add new columns to a table:

 

1.On the layout canvas, select the Table object you want to add columns to.

2.Select the data type for the new column from the drop-down list next to the Add Column button.

3.On the Table Properties panel, click the Add Column Universal - Add Column Button (Table) button within the Columns section.

 

flag_green

To change the column data type after the column has been added, select the column in the table properties and change the selection in the type column.

Document Icon

To delete a column:

 

1.On the layout canvas, select the Column to delete. You can select a column in one of two ways:

With the table selected, in the columns section of the Properties panel, double-click on the header cell of the row that describes the table column you want to select.

In the table itself within the layout area, click in the header area of the column. You will need to de-select (click somewhere outside) the table before doing this.

2.Press the Delete key on your keyboard or click the Remove Column Universal - TrashCan button.

 

 

Document Icon

To reorder columns:

 

1.Select the table object on the layout canvas for which you want to reorder columns.

2.On the Table Properties panel under the Columns section, find the column you want to move and click the Move Column Up or Move Column Down arrow buttons.

 

 

Document Icon

To re-size columns:

 

1.On the layout canvas, select the Column to re-size. You can select a column in one of two ways:

With the table selected, in the columns section of the Properties panel, double-click on the header cell of the row that describes the table column you want to select.

In the table itself within the layout area, click in the header area of the column. You will need to de-select (click somewhere outside) the table before doing this.

2.Change the Width property on the Properties panel or;

3.Select the Table object in the layout area and then re-size columns by clicking and dragging the column dividers.

flag_green

When you add extra columns or re-size existing columns, the table will extend to the right beyond the normal viewing area. Users will be able to scroll to see these columns.

 

See also: Using a Table to Manage Child Apps

 

Return to: Working with Tables, Designing an App