Universal table - convenient and efficient organization of any data

    The Simple Business program ( www.prostoy.ru ) was replenished with new functionalities designed to facilitate the quick access and use of information stored in the organization’s database. One of these possibilities is the use of a universal table as a single repository of information, with the help of which the user can easily receive all the necessary information about the interaction with the organization’s clients or any other data.
    The function of creating and changing the structure of a universal table is available for the program administrator and organization owner. For users with limited access rights, you can view the table and add data to it.
    Creating a new universal table is performed in the task window by clicking on the buttonimage- A universal table, which is located in the upper left corner of the task window.
    image
    When you select this command, a table appears on the screen in which the following fields are present by default: code, date of recording creation, date of editing of the recording, and author.
    The process of filling the table with data is not difficult for any user - all operations with table elements are performed using the buttons on the toolbar located on the left side of the window.
    image
    To create a new record, just click on the buttonimageeither use the “Add” command of the table context menu or the Ins key on the keyboard. Any of these user actions displays a form for filling data on the screen, at the top of which there is a search bar that allows you to quickly jump to the necessary information. After entering the necessary data into the form, you need to click OK at the bottom of the window - a new record will be added to the table. At the same time, information on the date of adding the selected record is displayed in the left pane of the window.
    image
    For universal table rows, there are various options for sorting records. To change the sort order, just left-click on the header of any of the columns in the table. Records will be sorted by the selected criterion in ascending or descending order.
    Editing records is carried out using the imagetoolbar button , you can also use the "Edit" command from the table context menu or the "Enter" key on the keyboard. Deleting a record is performed using the button image, the Delete key on the keyboard, or the Delete command from the table context menu.
    For any user of the program, it is possible to view the history of changes in records in the table and add comments to them. This function can be used on the “History” tab in the window of the selected object, which is opened by double-clicking the left mouse button on the desired record. All entries on the History tab are sorted in chronological order.
    image
    To facilitate the work of users with data in the "Table" window, various search options are implemented. In the "Search conditions" drop-down menu, it is possible to select one or several criteria from the proposed list - the fields corresponding to the selection will appear above the table.
    image
    The "Columns" button on the upper control panel enables the user to display the selected columns of the table on the screen by setting the corresponding flags in the drop-down menu. Information contained in hidden columns will be reflected in the left pane of the "Table" window.
    image

    To make changes to the table structure, you must use the "Settings" button. With its help, you can create, delete or edit new fields using the appropriate commands.
    The Copy and Paste commands perform the function of copying the table structure or pasting the structure of another table from another task.
    Table fields can be moved using the commands of the context menu "Up" (keyboard shortcut Ctrl + Up) or "Down" (keyboard shortcut Ctrl + Down).
    image
    The “View” option opens a form for adding data in the preview mode, where the fields for filling are presented as links.
    image
    At the top of the form is a search bar. When you enter a search term in a line, the field names under it are filtered out and only those that match the entered condition remain.
    When creating a new field (buttonimage“Add field”, “Add” context menu command or Ins key on the keyboard) the “New field” form is displayed on the screen, which defines the basic properties of the new field: name, type of field, field width, mandatory field and field availability options when executing search.
    image
    In the lower part of the window for the fields of the "List" type, you can specify the values ​​to select, add a group of users to the list (the "Users" tab), or a list of contacts (the "Contacts" tab). Setting the “Unique field” flag allows setting uniqueness criteria and the number of allowed repetitions.
    The “Advanced” tab allows you to set the value of the “default” field, as well as the conditions under which a table row will be highlighted in a certain color.
    For the convenience of information processing, the data of a universal table can be represented as a sheet of a MS Excel workbook. This operation is carried out by clicking on the “Export” button. In the window that appears, the columns for export should be marked with flags.
    image
    If necessary, you can perform the reverse operation - import the data from the worksheet of the MS Excel workbook into a table. This operation is performed using the “Import” button. In the data import window, the user can independently specify the column names using the context menu commands.
    image
    The use of a new element of the Simple Business program, a universal table, in the organization’s work makes it possible to increase the efficiency of work with any information, reduce and speed up the processes of synchronization and data retrieval, which increases the efficiency and productivity of the organization’s employees.

    Also popular now: