Parameter data types

In order to precisely adjust your input options for the parameter, the laboratory database offers the following adjustable data types. By choosing the right data type, you can achieve a high level of input security and avoid incorrect or unusable entries.

The following data types are available in the parameter settings:

numeric
Allows the input of numbers, e. g. 123. 45. If anything other than a number is entered, an error message appears.


string Allows the input of any text and numbers, e. g. not verifiable
a, b, c, custom Allows you to set up a selection field such as red, green, blue. Adding the custom entry at the end allows users to enter any value by selecting this option.

date Allows to enter a date with a calendar dropdown and prevents entries that do not correspond to the format DD. MM. YYY or DD. MM. YY. See also: _LINK_TO_PAGE=224_

time Enables the entry of times and prevents entries that do not correspond to the format HH:MM.

range Allows the value to be entered using a slider.

The slider is at the beginning in the middle and can be moved to the left (0) and to the right (100). Other ranges can be realized by a formula. For example, for the range -1 to +1, the formula is this(0)/50-1 or for the range 1 to 5, the formula is this(0)/25+1.


checkbox Allows a checkbox to be selected as input.

A selected checkbox is saved as 1 in the background.


samples Allows you to select an existing sample number. By combining with a sample label (=label), the sample selection can be limited to the samples from a certain label. To do this, use the notation samples=XX so e. g. samples=LM.
material Allows you to select a batch of all, or a specific material, displaying only batches that are released and have not expired at the time of selection. By specifying the material number material=X, the batch selection is restricted to a specific material (e. g. material=12). If you not specify a material number, the batches of all materials will show up material. See also: Linking materials with parameters
csv Transforms the field into a multi-line input field in which several numbers can be entered one below the other (e. g. for a series of measurements). See also: Calculating with number sequences

upload Transforms the field into a file upload button, whereby files (e. g. Pdf. Images,. . . ) can be uploaded directly into the input field. When uploading images, it should be noted that only images with the following formats are displayed in the report and in the image preview of a sample: . JPEG, . PNG, . GIF.

link This data type is suitable if you enter a link to a web page as a value, so that this link can then be clicked.
blocked Protects imported data or results calculated by formulas from manual entry and overwriting.
Further, the following combinations are possible with blocked: blocked_string blocked_date blocked_csv blocked_numeric
invisible Hides the input field. (Note: this data type (invisible) must be used as column header)
Regex A regex validation for a field between two / can be set: Example: /^([0-9]|1[0-4])$|^$/ For the pH Value only the values 0–14 or nothing is accepted:

Last change: 11.04.2025

Allgemeines

Einführungsphase

Mitarbeiter

Aufträge

Proben

Probenvorlage

Berichte

Kunden

Berichtstabellen Editor

Kundenzone (optional)

Anlagen

Rechnungen

Parameter

Rechnen mit Parametern

Schnittstellen

Webservice

Prüfpläne / Grenzwerte / Spezifikationen

Dokumentenlenkung

Prüfmittel

Material

Mitarbeiterschulungen

Sonstiges

PDF-Vorlagen

Fragen und Antworten

Dateiverwaltung

Auswertungen

Prozesse