Defining a Derived Field
To use the Derived Field Plug-in implementation script, you must first define a derived field. When you define a derived field, you apply a specific data field to each inspection or to each sample, and aggregate pass or fail evaluations.
To define a derived field:
-
Go to Customization > Lists, Records, & Fields > Record Types.
-
In the Quality Inspection Fields List row, click New Record.
-
Enter a quality inspection fields list record Name.
-
If you do not want this inspection field to appear in search lists and forms, check the Inactive box.
-
Select a Data Type for the data field:
-
Text – stores any kind of text data.
-
Integer – the most common numeric data type used to store numbers without a fractional component.
-
Decimal – provides an exact numeric in which the precision and scale can be arbitrarily sized.
-
Date – stores a date in the YYYY-MM-DD format.
-
DateTime – stores a value containing both date and time together in the YYYY-MM-DD hh:mm:ss format.
-
Boolean – represents the values true and false. It can also be represented as 0 (for false) and 1 (for true).
-
Image – store or refers to any type of image file. For example, .jpg, .bmp, or .png.
-
Select – represents a predefined list of string values that you can select from during data entry.
-
URL – captures an external URL for later navigation.
-
-
To make this a required inspection field, check the Mandatory box.
-
To identify whether the data field applies to each inspection or to each sample, check the Sampling Summary Field box, and then do the following:
-
To derive a value for the inspection field, enter your Plugin Script ID that calculates the derived value.
-
Enter a Derivation Description.
For example, To help calculate average value.
Note:To define a derived field, you must check the Sampling Summary Field box, and enter a Plugin Script ID and a Derivation Description.
-
-
Click Save.
Next, complete the procedures in Derived Field Plug-in Implementation.