Table Design

All the existing fields of the selected table will be shown on the taskpane Modify Table -page. In addition a new sheet will be opened showing the form for the table (Sheetform). Sheetform will be named as the table name with the "_Form" suffix.

The fields in the form will be initially located below each other in the order they have created. Field contains as many rows and columns as has been set on the field configuration (Initially 1 row and 4 columns). Field-area in the form has named as its field name.

You can freely move the field on the Sheetform but make sure that field-area maintains it name. You can also include additional texts and pictures to the form as in any sheet in Excel. The configuration of the Sheetform is saved in the Excel-file and will be available only for the users that have copy of the file.

Adding Fields

You can add new fields by clicking Add Field. A new field with default configuration will be added and the field-configuration page will be opened.

Adding SubTable

You can also add a (sub)table to a form by clicking Add Field. A table with row numbering will be added to the form and a tablefield (A Field with field type "Table") will be added to Table configuration. Tablefield configuration includes also the configurations of its columnfields.

Saving the Table and Form designs

Down in the taskpane page there are Save and Close -buttons. A confirmation request will appear above the button-row when you click Save-button. If confirmed the modifications to the table and form will be saved and table modification page will be closed. Close-button will only close the page and cancel all the made modifications.

As soon as you make any modification Undo Changes -button will appear. It cancels all the modifications made during the session and reload the table configuration from the database.