LIMS.eu

In the parameter settings, the following data types are available:

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 detectable).

text
Allows the input of multi-line texts.

a, b, c, custom
Allows setting up a selection field such as red, green, blue
If you add the entry custom at the end, users can enter any value by selecting this option.

date
Enables entering a date with a calendar dropdown and prevents inputs that do not correspond to the format DD.MM.YYYY or DD.MM.YY.
See also: Calculating with Date/Time Information

time
Enables entering times and prevents inputs that do not correspond to the format HH:MM.

range
Enables value input through a slider.

The slider starts in the middle and can be moved left (0) and right (100). Other ranges can be realized through a formula. E.g. for the range -1 to +1 the formula is this(0)/50-1 or for the range from 1 to 5 the formula is this(0)/25+1.

checkbox
Enables marking a checkbox as input.

A marked checkbox is saved as 1 in the background.
After deselecting, the field is empty again.

samples
Allows the selection of an existing sample number.
By combining with a sample range (=category), the sample selection can be restricted to samples from a specific range. Use the notation samples=XX for this, e.g. samples=LM.
When importing into these fields, the sample number is expected, see Tips for import interfaces

material
Allows selecting a batch from all, or a specific material, where only batches are displayed that are approved and not yet 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).
By specifying the material category materialtype=X, the batch selection is restricted to a specific material category (e.g. materialtype=123).
If a batch should be selected from all materials, use the data type material.

See also: Linking materials with parameters

equipment
Allows selecting a test equipment that has been stored in the corresponding parameter under "Test Equipment". It should be noted that at least two test equipments must be stored for the selection field to appear. Specifying the test equipment ID equipment=X does not work here.
If one should be selected from all test equipments, in addition to the preselection in the parameter, the specification equipment must be made in the column.

Note: In the system settings you can configure which test equipments should appear for selection here.

csv
Transforms the field into a multi-line input field where multiple numbers can be entered one below the other (e.g. for a measurement series).
See also: Calculating with number sequences

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

link
This data type is suitable when you enter a link to a website as a value, so this link can then be clicked.

blocked
Protects imported data or results calculated by formulas from manual inputs and overwrites.

Furthermore, the following combinations with blocked are possible:
blocked_string
blocked_date
blocked_csv
blocked_numeric

invisible
Hides the input field.
(Note: this data type (invisible) must be used as a column header)

Regex
Between two / a Regex validation can be built in:
Example: /^(0|1[0-3]|[1-9])([\u002E\u002C]\d|[\u002E\u002C]\d\d)?$|^14([\u002E\u002C]0|[\u002E\u002C]00)?$|^$/ (the comma is specified in Unicode so that no dropdown is created)
For the pH value, only values 0-14 or nothing can be entered:

Tip: have your favorite AI create your regex for you