Tabular Form

Since the "Salesman" is a database management system, a table is a principal type of a form. Such forms as references and Item Selection tables, journals and document's “Invoice” and “Delivery” tabs are designed as tabular sections. The form control elements for these forms are: the menu and control buttons, context menu. The table structure (a list of columns) of these forms is preset, and cannot be changed. Some tabular forms have a hierarchical structure, meaning that their elements can be grouped. In this case the data can be presented both as a hierarchical list, or with a disabled hierarchy.

Menu and Form Control Buttons

Settings

Each field (column) has the requisites that define how this column is displayed on your screen. You can change the requisites in "Menu" → "Settings"

Requisite Available values Description
Field (column) name A variable-length string Displays column name on the screen
Alignment Left, Right, Center Set the alignment of elements in the column
Width Integer Set column width in pixels
Number Integer Set column number in the tabular section
Visible true, false If “true” is set, the column is visible; if “false” - hidden
Stretchable true, false If “true” is set, the column expands until the table fills the whole screen; if “false” is set, the column has it's real width
Wrap text true, false if “true” is set, a column text displays in two lines if it doesn't fit one; If “false” is set, text will be clipped
Start in a new line true, false If “true” is set, the text displays in the srcond line; if “false” - in the first
Type Text, Integer, Real, Date Set the format of displaying the field value

Create a New Group

This option is available in the hierarchical tabular forms. As mentioned above, the elements can be grouped and thus displayed on the screen. To create a group of elements, use the menu item "Create a new group". Enter the name for a group and tap "ОК" to create it.

You can also create a new group inside another, one more group inside this new one, and so on. The number of levels is not limited. We created a navigation bar for convenient work with hierarchical data of a tabular sections. To enter any group just tap on it's name.

Filter

This feature is available in all tabular sections. It determines the selection order of the tabular section elements. Only the elements that satisfy the filter value will be displayed on the screen. You can activate it through "Menu" → "Filter". A filter can be set for any column. All you need is to select a desired column from a drop-down list and enter a criteria (filter value) in a corresponding window.

Only the elements that match the criteria will be displayed on the screen. The selection principle is "a substring in a string". To clear the filter value, press "х" in the bottom right corner.

Adding a New Element to a Table

Use the "+" button to add a new element to a table. This button is situated in the top right corner of the screen. When you tap it, a new element dialogue window appears on the screen. If you tap it in a document journal, a new corresponding document is created.

Hierarchy

Use the hierarchy button or a corresponding menu item to turn on/off the hierarchical order of displayed elements.

Sorting

The data in the table can be sorted by any column. Just tap a column header to do this. The arrow, that shows the order of sorting, will appear in the header. If it is down, the order is ascending; if it is up, then the sorting results are descending; if the arrow is absent, the data is displayed in the order of appearance. Please note, that the groups of elements are always on top. The sorting order you set is stored in all tabular forms even when you leave the table or exit the program. You can only change it manually.

Context Menu

The context menu varies according to the type of a tabular section. Its content differs depending on the actions that are available for an object. Each type will be considered in a corresponding chapter.