Table Window  

Contents

‘All collections’ table

Table for collection ‘Misc’

‘Table’ windows can be used to view records in a grid fashion. Using a table you can choose the fields you want to see, set the preferred column size, you can filter, browse, insert, delete and edit your records.

A table is related to a particular collection, except the “all collections” table, where you can see all records of all collections. In the “all collections” table you have the “collection” field, which is not available in the other tables.

The “all collections” table is also used to display the results of a global search.

You can open a table using the appropriate collection icon in the toolbar or the appropriate command in the main context menu. In addition, you can open a table by clicking the “table view of active form” icon when a non- table form is active.

Ordering records by column

By clicking on a column header, you will cause the records to be ordered by that column, in ascending or descending order (each time you click the direction is inverted). An asterisk placed after the column name will remind you which is the column currently used for ordering.

Adjustment of column size and visibility

By dragging and dropping the column separator, you can adjust the column sizes or even make a column invisible or visible again. The size of the table window itself can be adjusted by dragging and dropping the window’s borders.

The preferred setting of a table in terms of column sizes and visibility and form size is saved when you close the window and restored the next time you open it again. Preferences are saved on a collection basis, meaning that for every collection you can set different preferences.

Search prompt

Upon opening of a table for the ‘contacts’ or ’dictionary’ collections, a search window may appear, prompting you to insert a search pattern. If you are not interested in finding or filtering particular records, just press ‘ok’ or ‘cancel’ without entering any pattern.

Filters

For each visible column (except ‘expiration date’ and ‘reminder date’ columns) a filter box is available. You can enter characters in these boxes in order to have a filtered view of the collection. For the ‘category’ column (and the ‘collection’ column in the ‘all collections’ table) a lookup list is available from where you can choose among all the different values present in that field for all records. Every time a filter is changed, the table is regenerated according to the new filter.

The button ‘clear’ will clear all filters at once. The ‘and’ and ‘or’ options will determine whether filters should be applied as an ‘and’ or ‘or’ expression.

Filters are automatically set after a search or global search operation.

Editing records using edit boxes

For each visible field an edit box is available. As the ‘content’ field may contain up to 30031 characters, an additional, larger edit window is available for this field and can be opened by pressing the ‘zoom’ button.

Field ‘category’ (and field ‘collection’ in the ‘all collections’ table) can be filled by means of the available lookup lists, which allow you to select among the different values already present in the database for the applicable collection.

Fields ‘expiration date’ and ‘reminder date’ can be checked or unchecked for any given record. When checked, the record becomes visible in the calendar window. When unchecked, these fields are considered null and the record is not taken in consideration in the calendar window.

Editing records directly on grid rows

You can edit record fields directly on the grid rows. In order to save the change, you can just move to another row or press the ‘save’ button.

Use of the ‘id’ field with collections ‘books’ and ‘media’

When inserting a new record from a collection table the ‘id’ field will be automatically filled with the highest number found in that field for that collection, increased by one. This may be useful to assign unique serial numbers to your records. Anyway, you can modify the content of this field at any time.

Creating file and directory links

The ‘file’ and ‘dir’ buttons can be used to create file and directory links in the ‘content’ field of a record. This can be done for any collection, not just the ‘file links’ collection.

Canceling edit/insert operations and closing the window

If an edit or insert operation is open, you can cancel it by pressing the “cancel” button or the “ESC” key. If you press the “cancel” button or the “ESC” key while no insert or edit operation is open, this will cause the table window to close.

Altering the record sequence by drag and drop

You can alter the record sequence by dragging and dropping rows in the position you prefer. It is required that you keep the ‘shift’ key pressed while you do this operation. If the new position implies a change of category, the program asks you to confirm the change of category. If you do not confirm it, the move operation will be cancelled.

Context menu commands

See Table Context Menu for all commands applicable to this window.