Welcome to Catalog Tips

Search more than 200 articles to learn more about creating and automating your product catalogs

Tip: Start typing in the input box for immediate search results.

< All Topics
Print

FIELDVAL – Display value of field

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

Table of Contents