Andmebaas

You can insert fields from any database, for example, address fields, into your document.

Selle kÀsu kasutamiseks...

Vali Lisamine - VÀljad - Muud vÀljad - kaart Andmebaas


TĂŒĂŒp

Lists the available field types.

VĂ€lja tĂŒĂŒp

TĂ€hendus

Iga kirje

Inserts the contents of the database field that you specify in the Record Number box as a mail merge field if the Condition that you enter is met. Only records selected by a multiple selection in the data source view are considered.

You can use this field to insert several records into a document. Simply insert the Any Record field in front of the form letter fields that use a certain record.

Andmebaasi nimi

Inserts the name of the database table selected in the Database selection box. The "Database Name" field is a global field, that is, if you insert a different database name in your document, the contents of all previously inserted "Database Name" fields are updated.

Kirjakooste vÀli

Inserts the name of a database field as a placeholder, so that you can create a mail merge document. The field content is automatically inserted when you print the form letter.

JĂ€rgmine kirje

Inserts the contents of the next mail merge field in your document, if the condition that you define is met. The records that you want to include must be selected in the data source view.

You can use the "Next record" field to insert the contents of consecutive records between the mail merge fields in a document.

Kirjenumber

Lisab valitud andmebaasikirje kirjenumbri.


note

The following fields can only be inserted if the corresponding field type is selected in the Type list.


Andmebaasi valimine

Vali andmebaasitabel vÔi andmebaasipÀing, millele vÀli peab viitama. Saad dokumenti kaasata mitme andmebaasi vÔi pÀringu vÀljad.

Tingimus

Tingimusega lingitud vÀljade jaoks sisesta siin kriteeriumid.

If you want, you can assign a condition that must be met before the contents of the "Any Record" and "Next Record" fields are inserted. The default condition is "True", that is, the condition is always true if you do not change the condition text.

Kirjenumber

Sisesta kirjete arv, mida soovid lisada, kui mÀÀratud tingimus on tĂ€idetud. Kirjete arv vastab andmeallikavaate praegusele valikule. NĂ€iteks kui valid kĂŒmmet kirjet sisaldavas andmebaasis viis viimast kirjet, on esimese kirje number 1, mitte 6.

MĂ€rkuse ikoon

If you refer to fields in a different database (or in a different table or query within the same database), LibreOffice determines the record number relative to the current selection.


Vorming

Select the format of the field that you want to insert. This option is available for numerical, boolean, date and time fields.

Andmebaasist

Kasutab andmebaasis mÀÀratletud vormingut.

Lehitse

Avab faili avamise dialoogi, milles saad valida andmebaasifaili (*.odb). Valitud fail lisatakse valitud andmebaaside loendisse.

Kasutaja mÀÀratud

Rakendab loendis Kasutaja mÀÀratud vormingute loend valitud vormingu.

Kasutaja mÀÀratud vormingute loend

Lists the available user-defined formats.

TĂŒĂŒpkirja printimine

Kui prindid andmebaasivĂ€lju sisaldava dokumendi, kĂŒsib dialoog, kas soovid printida tĂŒĂŒpkirja. Kui vastad jaatavalt, avaneb dialoog Kirjakooste kohas, kus saad valida prinditavad andmebaasikirjed.

Palun toeta meid!