Skip to main content

FieldValue - script and chart function

FieldValue() returns the value found in position elem_no of the field field_name (by load order).

Syntax:  

FieldValue(field_name , elem_no)

Return data type: dual

Arguments:  

Arguments
Argument Description
field_name Name of the field for which the value is required. For example, the column in a table. Must be given as a string value. This means that the field name must be enclosed by single quotes.
elem_no The position (element) number of the field, following the load order, that the value is returned for. This could correspond to the row in a table, but it depends on the order in which the elements (rows) are loaded.

Limitations:  

If elem_no is larger than the number of field values, NULL is returned.