Forms
The following sections describe how to use Forms in Scifeon. Forms are used to register data in Scifeon.
The following tutorial explains how to create a Procedure for registering Batch Records: Recording Batch Records - this tutorial also on a general level explains how to use Forms.
Creating and editing Forms
In the ELN click + Section (1) and select Add Form, then after that click the cog-wheel (2) and click Create new field (3):
Here you fill out this information:
- Name (1): The name of the field, which will be used in the database.
- Label (2): The label of the field, which will be shown to the user.
- Type (3): The type of the field, e.g. Text or Number.
- Variable (4): Fill out if you want to use the value of this field in a calculation.
Click Save or Save + Create New Field to save the field.
Multiple Columns
It is possible to record data for multiple subjects in a form. Currently only Samples are supported as subjects. To enable this, click the cog-wheel (1) and click Configure Form (2):
In Configure Form, click Multiple Columns (1) and select Sample Source e.g. Step Input, and select the current Step (3):
You will see the Samples (4) and when you Save form (5), you will see that the form has been split into multiple columns, one for each Sample:
Field types
The following field types are available:
Select Entity
This field type is used to select an entity from the database. The value of this field type is the selected entity. This field type is used to e.g. select a Sample, a Product, a Batch, etc.
Select the Entity Class (1) and optionally limit the types of entities that can be selected by selecting Entity Type(s) (2). The Entity Metadata (3) can be used for showing additional information about the selected entity directly in the form:
Now when selecting an entity, the metadata will be shown and the entity itself can be clicked to see more details. Please note that the metadata shown is the metadata of the entity at the time of form submission, so if the metadata is changed after the form is submitted, the metadata shown in the form will not be updated, unless explicitly when editing values of the form.
Reference
This field type is used to reference another field in a form in the same experiment. The value of this field type is the value of the referenced field. E.g. the instrument selected in the example above can be selected like this, where the Form (1) is selected and then the Field (2) is selected:
And it will then render like this in the form:
Calculations (formulas)
This field type is used to calculate a value based on other fields. The value of this field type is not editable by the user. This can e.g. be used to calculate averages, time differences, etc. This is usually done with simple arithmetic operations, but it is also possible to use more advanced functions, such as IF and SUMIF, like you are used to from e.g. Excel. A list of available functions is available here
Here are some examples of calculations:
// Calculate the average of the fields a, b, c:
AVERAGE(a, b, c)
// Time difference between the fields "Start time" (a) and "End time" (b)
INT(b-a) & " days, " & HOUR(b-a) & " hours, " & MINUTE(b-a) & " minutes"
Calculations are entered in the Calculation formula field:
Snippets
Snippets are useful for using the same group of form fields over and over again, without having to re-define the fields.