Displays database

Modified on 2009/10/06 09:03 by stefano Categorized as Uncategorized
==Displays database == {s:Related}
The first time that you select a database will be inserted data, tab to insert will therefore appear:

{{<img src="{up}Manuale IT/11.1.2 database - db manager - visualizza database00.PNG"/>}}

Fill in the various fields in a timely manner (those with * are mandatory), bearing in mind that:

* the date type directly to populate a field whose data type is a date (dd = day 2 digits; MM = month 2 digits; yyyy = year 4-digit, e.g. 01 01 2009), or click on the icon {{<img src="{up}Manuale IT/seldate.PNG"/>}}:

{{<img src="{up}Manuale IT/calendario.PNG"/>}}

So you can select the date from the calendar, clicking on the desired day directly. To change click on {{<img src="{up}Manuale IT/monthprev.PNG"/>}} month (previous month) or {{<img src="{up}Manuale IT/monthnext.PNG"/>}} (next month). To close the window click {{<img src="{up}Manuale IT/X orange.PNG"/>}};
* to populate a field whose data type is a contact, a company or a click {{<img src="{up}Manuale IT/face.png"/>}} lead, search box will appear (see for more information about the search for companies and contacts window [New leads] between lead research is quite similar to that between contacts);
* time type directly to populate a field whose data type is an hour or adjust through buttons {{<img src="{up}Manuale IT/timeup.PNG"/>}} and {{<img src="{up}Manuale IT/timedown.PNG"/>}}; once compiled all fields required/desired {{<img src="{up}Manuale IT/SALVA.PNG"/>}}; click to cancel the insertion click {{<img src="{up}Manuale IT/ANNULLA.PNG"/>}}.

The rescue of the first given will appear the following summary screen:

{{<img src="{up}Manuale IT/11.1.2 database - db manager - visualizza database01.PNG"/>}}

To edit the inserted data click {{<img src="{up}Manuale IT/modifica.png"/>}}. To view click on {{<img src="{up}Manuale IT/ANNULLA.PNG"/>}} table.

To insert a new item click on "Add records", when there are 2 or more elements will be following the summary table:

{{<img src="{up}Manuale IT/11.1.2 database - db manager - visualizza database02.PNG"/>}}

To return to the list of databases click "Close".

To print database click "Print".

To display the table that lists all the fields click on "All fields"
To delete an item, select the box in the last column, and then click {{<img src="{up}Manuale IT/CESTINO.PNG"/>}}.

To view and possibly change an item click on an entry line.

To sort alphabetically a click on the title of the column column data; to reverse the sort order click again.

Lower right following the number of entries, however, is the number of items listed in each list is limited ({{<img src="{up}Manuale IT/SETUP.PNG"/>}} {{<img src="{up}Manuale IT/SETUP gestione account.PNG"/>}} ([Account management]), tab "Configuration Tustena" ([Tustena configuration|Tustena configuration])). To view items that follow click on the number for the list page or on "Next" to switch to the next page. To go back a page click on "Previous". To display all entries in a single page click on "All records".

To search between data reported in the various fields click on "Search":

{{<img src="{up}Manuale IT/11.1.2 database - db manager - visualizza database04.PNG"/>}}

Fields in a timely manner, bearing in mind that:

* to set the time restrictions, select if the date of the item should be less than or equal (≤)
), uguale≡
) or greater or uguale≥
) the date of reference to be following in the "Date validity" pane: you can manually type the date (dd = day 2 digits; MM = month 2 digits; yyyy = year 4-digit, e.g. 01 01 2009), or click on the icon {{<img src="{up}Manuale IT/seldate.PNG"/>}}:

{{<img src="{up}Manuale IT/calendario.PNG"/>}}

So you can select the date from the calendar, clicking on the desired day directly. To change click on {{<img src="{up}Manuale IT/monthprev.PNG"/>}} month (previous month) or {{<img src="{up}Manuale IT/monthnext.PNG"/>}} (next month). To close the window click {{<img src="{up}Manuale IT/X orange.PNG"/>}}; * to set up a time interval of validity select dates in the boxes "(Range)";
* to populate a field whose data type is a contact, a company or a click {{<img src="{up}Manuale IT/face.png"/>}} lead, search box will appear (see for more information about the search for companies and contacts window [New leads|New leads] between lead research is quite similar to that between contacts);
* Once you have selected the desired parameters click {{<img src="{up}Manuale IT/CERCA.PNG"/>}}, are listed in the list only those entries.

By clicking on "CSV", "CSV (...)" or "TXT" you can export the data in the corresponding format.
Meta Keywords:
Meta Description:
Change Comment:
ScrewTurn Wiki

Navigation (Manual)¶

Displays database
