Design Repexel Tables

In the Design Tables menu you'll see all the reporting templates, that you have administration right to modify. In a stand-alone version you have access to all the tables, forms and entries in the solution. Access rights are managed only in the multi-user database environments. In a multi-user environment you can see the entries based on your access rights.

By clicking edit button () the configuration of the respective form/table will appear in the taskpane for you to modify.

By clicking the delete button () the form/table will be removed from database and an undo button will replace the edit and delete buttons. If you wish to undo the delete, you can click the undo button (), but you must do it before you leave the Manage Forms/Tables taskpane or change the active sheet.

New Table

You can build a new Table by clicking the New Table -button. An empty Table form will appear on the taskpane that you can then modify and save.

Generate Table

You can generate a database table from a existing data in a Excel worksheet. Select any cell(s) in a Excel table or the complete range of the data rows that are to be used to generate the database table. In any case the first woe of the table or selected range has to be header row and consist of the field names.

The selected range has to have header row as the first row containing all the field names.

Then click the Generate Table and the Repexel Table design form will appear in the taskpane. There will also open a new worksheet with a default Form Design of the generated Table.

You can then remove the fields that you don't want to be included in the database. You can also add new fields to the new Table.

If the table or range where the Repexel Table is generated has data rows in it, then there will be "Save Entryrows" -checkbox in the Table Desing taskpane. By checking that the datarows in he source data will be uploaded to the new Repexel Table in the database.