Table Widget

Basics

The Table Widget it quite a complex Widget with lots of options. Its basic purpose is to display tabular data. The same component is used in the Grid View, so the behaviour of a Grid View and the Table Widget inside a form is very similar. The real difference is that in the Grid View the table contains all your data, whilst when it is used in a form it usually only contains part of your data. It has this icon in the form builder Design mode toolbar:

The Table Widget is for displaying multiple rows of data. For master-detail data this can be this can be multiple rows of the master or the detail (but not in the same table!). A set of Fields specify the columns in the table. These are the Fields that are bound to the Widget. Correspondingly the Table Widget, unlike other current Widget types, can be (is designed to be) bound to multiple Fields.

The behaviour of Table Widgets in terms of navigation and selection can be complex when working with master-detail data. Please read the Browse Mode documentation for a detailed description.

Design Mode

You add a Table Widget to a Form by dragging its icon onto the canvas, after which the Bind Dialog will open. In the Bind Dialog you can specify multiple Fields for the columns in the table, but they must all be from the same Entity. Use Shift-click and Ctrl-click to make multiple selections. Alternatively, if you want all the Fields for an Entity just select the Entity.

After you have completed the bind process the table will appear on your form, and dummy columns and rows will be present to indicate the Table Widgets contents. You can then re-size and re-position the Widget as normal.

Browse Mode

In Browse mode the Table Widget will display your data. Scroll bars will be present if necessary. The selected row, column or cell(s) will be highlighted. This selection controls the display of any other Widgets that are bound to Field from that Entity or any that are from Entities that are from child vertices in the Data Tree. See the documents on Relationships and Data Trees for a fuller explaination of how relational data is handled in Instant JChem.

Data in the Table Widget can be sorted by one or more column values. This operates similarly to the Grid View, and the sort directives are displayed in the column headers.

In Browse mode the columns in the table can be re-ordered (drag the column header to the new location) and resized (drag the right hand edge of the column header). The column widths operate in two modes:

Fit to width - all columns fit into the available width
Actual width - columns use their specified width, and a horizontal scrollbar is used if necessary

To change between these settings use the Size Tool that is accesible from the top left corner of the Table Widget.

The row height can be adjusted by using the row height adjuster present in the Size tool, or by dragging on the row dividers in the row header. All rows in the table have the same height.

Table Settings

To edit the settings in Design mode double click on the Widget and the settings editor will open. In Browse mode double click in the border area (not the main area where values are displayed. Alternatively select the widget in either mode by single clicking on it and then click on the Widget Settings icon () in the Form toolbar. The settings dialog can also be opened from the size tool (see above).

The settings editor lets you control the settings for each column in the table. You can also modify which Fields are bound to the Widget, and hence which columns appear in the table. This can be done in Browse mode.

Query mode

In query mode the table widget behaves very similarly to the grid view query node. A single row is displayed and you can specify query critieria in the cells of this row in a similar manner to the equivalent form widgets.