Table of Contents
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 CONCAT, FIELDSTR 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.