First value of a field

[#1]

Hi,

How do I extract the first value of a field according to load order?

Thanks

[vishsaggi · Accepted solution]

Try this :

FieldValue()

Ref:

Fieldvalue(fieldname , n)

Returns the field value found in position n of the field fieldname (by load order). Fieldname must be given as a string value, e.g. the field name must be enclosed by single quotes. The first field value is returned for n=1. If n is larger than the number of field values, NULL is returned.

Note: This function will only work with distinct field values.

Example:

fieldvalue( 'Helptext', 5 )