Table of Contents
Overview
This Custom Field returns the string contents of a field. It is usually used in conjunction with other Custom Fields.
Syntax
FIELDSTR(FieldName)
| Element | Description |
|---|---|
| (FieldName) | The field name |
Example
1. FIELDSTR(‘Height’) for the table below will return 178, 165, 202, 194.
| Height |
| 178 |
| 165 |
| 202 |
| 194 |
2. CONCAT(‘His height is ‘,FIELDSTR(‘Height’)‘,’ centimetres and his weight is ‘,FIELDSTR(‘Weight’),’ kilograms.’)
| Height | Weight |
| 178 | 78 |
| 165 | 70 |
| 202 | 98 |
| 194 | 98 |
For the values in the above table, the command above incorporating the Custom Fields CONCAT and FIELDSTR will return the following four results:
1. His height is 178 centimetres and his weight is 78 kilograms.
2. His height is 165 centimetres and his weight is 70 kilograms.
1. His height is 202 centimetres and his weight is 98 kilograms.
1. His height is 194 centimetres and his weight is 98 kilograms.