Manage Entries

In the Reporting taskpane clicking the filter button () on the row of a Table name, the Reporting Filter page will be opened in the taskpane revealing filtering options for that Table.

Time Filter

In the Reporting Filter taskpane you will have time filter to filter the Entries based on the time they have in the field, that has been indicated as the Time field of that Table.

Reporting period is based on the Time field. Alternatives for reporting periods are: Year, Month, Day or Hour.

In case the reporting period is Year or Month there is an alternative to report only information of one period. There will be then a checkbox to choose whether you prefer to do reporting for multiple periods

If there is no Time field on the table or you have checked the Any Time -check box, then the time filter will be hidden.

Field filters

Below the time filter section is the section of Field filters. These filters are based on the Field values in the Table, and they can be either required or optional filters.

Required Filters

In required Filters there can be only one filter value and it cannot be empty. Options for the required filter values are presented in a dropdown list. The first option in the list is the default value.

Optional Filters

In Optional Filters you can choose one or more options for accepted values. Clicking the Filter button on the right of the Filter name, the list of first level options will be revealed under the filter's name.

If there is a hierarchy on the values, then the list can be expanded by clicking with a right mouse click.

Selected Entries

Clicking the Load will retrieve the filtered Entries to a table on a new worksheet named according to the database Tables name. If there already exists worksheet with the name, then the new worksheet will have a numbered suffix.

On top of the emerged worksheet is a header section where there is the information of data retrieved. There is the name of the database table and possible field and time filters.

Under the header section there are the retrieved entries in a table with field names in the table header.

Protected sheet

The Entries table worksheet will be protected, and you cannot write to the first four rows in the sheet to the right end of the table. To the right of the table and below the table you can use to make worksheet specific entries and calculations. Just remember that writing to the row just below the table will generate new row(s).

Adding, Modifying and Removing Entries

Adding Entries

You can add a new row to the table by filling the cells to the row below the table. You can also paste multiple rows so that the first added row is next row below the table-

Modifying Entries

You can modify the Entries within the Table. You can also use Formulas and references to other cells in the cells as long as the result is the right format for the field.

Deleting Entries

You can remove a row in the table by deleting all the editable fields on that row. The row will be removed.

Saving Entries

When any changes has been made to the retrieved entries the Save icon in the Repexel menu will be activated. If any Field filters or Time filter is active, then Save will replace all entries complying those filters with the entries on the table. If no filter is applied all the entries will be saved as new ones. However, if there exists an entry with the same identification values then it will be replaced.