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:
