String manipulation

FIELDVAL – Display value of field

58 views June 1, 2018 admin 0

Overview

This Custom Field returns the numerical contents of a field. This function will only return a value for numeric fields, such as number or currency.

Syntax

FIELDVAL(FieldName)

Element Description
FieldName The field name for which the numerical contents will be returned.

Example

1. FIELDVAL(‘Price’) for the table below will return 78.00, 70.00, 98.00, 56.00.

Price
78.00
70.00
98.00
56.00

2. CONCAT(‘The ‘,FIELDSTR(‘ClothingItem’),’ costs $’,FIELDVAL(‘Price’),’.’)

ClothingItem Price
Jumper 78.00
Shirt 70.00
Jacket 98.00
Hat 56.00

For the values in the above table, the command above incorporating the Custom Fields CONCATFIELDSTR and FIELDVAL will return the following four results:

1. The Jumper costs $78.00.

2. The Shirt costs $70.00.

3. The Jacket costs $98.00.

4. The Hat costs $56.00.

See also

FIELDSTR

FIELDNAME

Was this helpful?