USER MANUAL
Database

A site database is a set of tables belonging to external pages.
A page database is a set of tables belonging to an external page.
You can apply: just a table, 2 related tables, 3 related tables.
Communication in the tables is carried out according to the dynamic key (number in order) in the ratio of 1 to many.
The heading of the subordinate table is always the value of the columns. the parent table in which the "Template" field, the first character is the "+" character.

Each table has the following functional:

entry of table rows,
changing table rows,
deleting table rows,
insert table rows,
adding table rows,
replacing data in rows of a table,
hiding table columns,
unhiding columns,
change the default values,
summarize numerical columns,
sorting table rows,
selection of table rows,

setting the group size,
group navigation
setting up a monopoly,
cancel of monopoly,
password setting,
password reset,
go to line,
table printing,
print table properties,
add and remove buttons,
editing the codes of the inserted buttons,
table changes:
- changes to column properties: type, heading, default value, value conditions, notation;
- delete a column;
- insert a column.

administrator
add and / or view.

Table operating modes and table accesses

Multi-user access to the table.

browse tables,
selection,
sort
view the properties of the table,
print tables,
add rows to the table with or without a password if no password has been set.

Exclusive access to the table

Admin Mode

On the site, click on the ENTER link.
Enter your password.
If logged in as an administrator, click the "Administrator" link.
In the "List of Internal Pages" table, click the "Page Name" column in the row of the page in which the database is created or in which the table will be created.
In the "Page Objects" table, click in the "Name" column to open the table.
Exclusive access is required to perform the following tasks:
1. in the table and in the list tables:
  1. deleting table rows,
  2. insert table rows,
  3. insert deletion change table columns
2. in the list tables of list fields:
  1. deleting table rows,
  2. insert table rows,
  3. insert deletion change table columns
  4. editing table rows
  5. editing table buttons

Creating a database table

On the site, click on the ENTER link.
Enter your password.
If you are logged in as an administrator, click the "Administrator" link.
In the "List of Internal Pages" table, click the "Page Name" column in the row of the page in which the database will be created.
Click the “st1” button to insert a table on a page, “st2” to insert 2 related tables on a page, “st3” to insert 3 related tables on a page.
Click the row of the created table, in 1 column.
Change the name to the required one and click the "Change" button.
Repeat the 3 preceding paragraphs as many times as there are tables on the selected inner page.
To create tables on other internal pages, in the List of Internal Pages table, click the column for the following page and continue with p. "Click the" st1 "," st2 "," st3 "button."

NOTES:

Do not change the number of the table, it defines the table and its related pages of links.
You can create a table as an external page, for this, in the "number" field, enter the number in the form of 0.00,000 [table serial number], the selected date and the entered number must not coincide with the date and the number that is already in the table row.

Create link pages of the database table

On the site, click the ENTER link.
Enter your password.
If logged in as an administrator, click the "Administrator" link.
In the List of Internal Pages table, click the Page Name column in the row of the page in which the database is created.
In the "Page Objects" table, select the created database by clicking and click the "show" button.
Form opens:
Check the "template" checkbox if you want to add a page from a previously created template copying it.
Click the + button.
Click the line of the created page.
Change the name to the required one and click the "Change" button.
Repeat the 3 preceding paragraphs as many times as there will be link pages (rows in the base table).

NOTES:

Do not change the page number of the link; it determines whether the link belongs to the database table.
You can convert the link page into an external page, for this in the "number" field enter the number without 0,00,000 and the symbol v, click the "Change" button.

Sort by table.

A table can be sorted by any column.
To sort in ascending order, check the “Ascending” box.
To sort in descending order, clear the “Ascending” checkbox.
Click the header, in 1 row, the column by which you want to sort.
To cancel sorting, click the selected column in the header (second click).

Transition in the table.

To go to the end of the table, click the down arrow button.
To go to the beginning of the table, click the up arrow button.

Selection in the table.

Click the header, in line 2, the column by which you want to select.
In the "filter" field, enter a list of selection contexts.
A list of contexts, these are contexts separated by a "/" character.
Rows are selected by matching contexts from the list with any part of the text of the selected column.
Rows are selected for the number in order, according to the complete coincidence of the number values and the list of values.
To select, click “Select”.
To deselect, click Cancel.

Print the table.

To print the table, click the P button.
Printing is subject to selection and sorting.

Create and delete subordinate tables

On the site, click the Enter.
Enter your password.
If logged in as an administrator, click the Administrator link.
In the PAGE OBJECTS table, click the table to be modified and the table opens.
Open the subordinate lower-level table by clicking on the "Go to child" button.
Click the "A" button to open the admin commands.
Set monopoly, if not set, by clicking on the Set Monopoly button.
Click the "Change tables" button - a form will open:
To delete a table, mark it in the X column.
To add a table, on the last line, enter the table name.
Click the "+" button to add the last line.
To change the name of the table, click in the Name column and change the name.
Click the Execute button to save your changes.
The first table is not dropped!
The first table at the first opening of the form has no name, please enter it!
To close the form without saving changes, click the X button.

Data types in the table

t - text (input of any characters except # is allowed, input of tags except < br > (from a new line) and & nbsp; (space) is prohibited;
d - date (dates can be entered in a certain interval and in a specific format);
i - an integer (input of integers is allowed, in a certain interval);
$ - money (money can be entered with an accuracy of a penny, in a certain interval);
L - list (combo box) (it is allowed to select and display the text value from 2 columns, from the list table);
a - link (you can select a link to an external page from a variety of external internal pages, with certain requirements for page names or any page of a site.)

Some Data Properties

You can prevent data from changing in the column by placing the ^ character at the end of the header.
You can set unique values by placing the ~ character at the end of the header.
You can hide the table columns of the lookup field by placing the * character at the end of the header.
You can enter values in 2 columns and only from the global data table, if at the end of the header put the symbol =.

Table form description

Fig. 1. The table form is open in multi-user access by clicking on the link on the site page.

The form consists of:

Table names.
Fixed row of column numbers.
of the table itself.
Message lines and replacements.
input fields.
control buttons.
Group volume selection switches.
Chart Switches.
Fields for entering the line number and buttons for the transition.
Information about the total number of lines and the number of lines displayed.

View table

When opening a table, by default, a group of the last 10 rows entered is displayed.
If the table has columns with unique values, all rows are displayed.
The table is viewed in groups.
To change the number of rows in a group, click one of the “Rows in group” radio buttons and then one of the “To Group” buttons.

Browse Groups

Click the radio switch with the desired group size.
Click one of the buttons: “1 group”, “last group”, “previous group”, “next group”.

Go to the number

In the field per line, enter the line number to which you want to go.
Click the Go! button.

To go to the line with contexts from the list of contexts

In the field to the left of the “To!” button, enter the transition contexts in the form of fragments of text through the separator /
Click the “To!” button.
A transition will be made from the row in which the selected column contains (in any part) context from the entered list of contexts.
Transitions are completed by issuing the message “End”.

Go to child table

In the parent table, click the row you want.
Click the "Subordinate Linked Table" button (to the left of the ENTER header).
or just click an empty space in the last column of the page

Go to parent table

Click the Parent Table button (to the left of the ENTER heading).

Row and column selection

To select a row and column, click the highlighted column in the highlighted row.
To select a column, click the corresponding input field.

Hide and show columns

To hide the column, after selecting it, click Hide Column (H).
You can hide all columns except the checkmark column.
To display all columns, click Show All Columns (V).

Column sum calculation

Click a numeric or monetary column.
Click the S button, the sum value appears in the column input field.

Sorting

Sorting is performed on the rows of the group, taking into account the selection and hiding of columns.
Sort by one column.
To sort, highlight the sort column and click Sort Ascending or "Sort Descending."
To cancel the sort, click Cancel Sort.

Table row selection

Selection is made over the lines of the group by clicking the "!" button or the "only" button.
Reverse selection is performed on the lines of the group by clicking the “!” button with an overline or the “except” button.
The selection is made on the server above all the lines when the “!!” button is clicked, and a group is formed.
The selection is made for all columns except "N pp" and "link".
Selection by list fields is performed not by field value, but by key.
The list of keys can be obtained by clicking on the corresponding condition field.
To include a value in the selection list, click the cell with that value and click the “+?” button.
To select, click the question mark button.
To deselect, click the crossed out question mark button.
The table list opens. Figure 3. A window for changing the value of the list box appears if you click the select box
In the “Selection” column, select the checkboxes in those rows, by the values of which you want to select and click the “In selection” button.

A selection form will open, in the selection fields for which rows in the "Selection" column have been marked in the forms of list fields and the "In selection" button has been clicked lists to select are displayed. Fig. 2. The selection window appears if you click "Open the selection form"
Enter the selection data in the selection fields and click the “Select” button.
When entering into the list selection field, use the / symbol as a separator. The selection list can be set:
To enter values on a selection of numerical fields, use the result in the calculator
To enter an arithmetic expression or number in the input field, enter a number or expression.
Click the expression field in the calculator.
Click "=".
Click the select box.
To enter dates in the selection fields, click the date in the calendar and then click the selection field.
To cancel the selection, click the “Cancel” button.
To deselect a single column, click the row in the “Name” column.
To clear the selection fields, click the "C" button.
To close the selection form, click “X”.
You can cancel the selection by clicking on the button with a crossed out question mark.

Selection lists

Fig. 2-1. Selection List Controls

Add a selection to the list

Enter or change the selection conditions.
Enter the name of the selection in the input field.
To add to the end of the list, click “add”.
To add before fetching: open the list, click the selection before which you want to add and click "insert before".
To add after the selection: open the list, click the selection after which you want to add and click "insert after".

Change a selection from a list

Open the list, click on the selection you want to change.
Change the selection conditions.
Click edit.

Removing a selection from the list

To delete a selection: open the list, click on the selection you want to delete and click “delete”.
To delete the entire list, click “erase”.

Saving the selection list

To save the changes to the selection list, click save.

View table properties

Fig. 2. The table properties window appears if you click button 1, ...

Adding Rows

for admin,
for a user who knows the password,
for all users if the table password is not set or canceled.

Select the last row of the table and click the "Insert after" button, or click "Add to the end".
A row appears with the serial number “?” and column values equal to “default values”.
To temporarily change the default values, select the row of the value table you want to make default values and click the "d" button.
In the same way, you can move a table row.

Row change

for admin,
for a user who knows the password,
for all users if the table password is not set or canceled.

Click the row of the table you want to change.
Click the input field:
if the input field: text, integer, money, date, edit the value;
if field: link, list, the corresponding list opens,
click the desired row of the table and click "Replace".
click the next row of the table you want to edit and edit it;
finish editing the last line by clicking on it.
Modified rows are marked with an “r” in the “r x” column.
to save changes to the server, after entering all the changes, or part of the changes, click "Save to server".

Fig. Large text editing window

NOTE:

Copy columns

Executed by the administrator in exclusive mode over the group, taking into account the selection.

in the “what’s changing” field, enter the number of the column to be copied,
in the field “for what we change”, enter the number of the column where you will copy,
columns must be of the same type,
click the copy column button,
click the save button.

Fill Columns