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: Rechnen mit Datums-/Zeitangaben




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: Material mit Parametern verlinken


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: Rechnen mit Zahlenreihen




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: 16.01.2024

Allgemeines

Einführungsphase

Mitarbeiter

Aufträge

Proben

Probenvorlage

Berichte

Berichtstabellen Editor

Kunden

Kundenzone (optional)

Anlagen

Angebote

Rechnungen

Parameter

Rechnen mit Parametern

Schnittstellen

Webservice

Transformationscode

Prüfpläne / Grenzwerte / Spezifikationen

Dokumentenlenkung

Prüfmittel

Material

Mitarbeiterschulungen

8D-Report

Sonstiges

PDF-Vorlagen

Fragen und Antworten

Lieferantenbewertung

Dateiverwaltung

Auswertungen

Prozesse