Table of Contents
Overview
This Custom Field concatenates (joins) separate strings into a single string.
Syntax
CONCAT(Argument1,Argument2,Argument2)
CONCAT(FIELDSTR(Description1), text, FIELDSTR(Description2))
| Element | Description |
|---|---|
| Argument1 | A string, e.g. the contents of a specified field. |
| Argument2 | A second string, e.g. freeform text. |
| Argument 3 |
A third string, e.g. the contents of a specified field. |
Example
A clothing manufacturer has jumpers and shirts available in red and green and jeans in blue and black.
| Product Name | Product Colour |
| Jumper | Red |
| Jumper | Green |
| Shirt | Red |
| Shirt | Green |
| Jeans | Blue |
| Jeans | Black |
CONCAT(FIELDSTR(‘ProductColour’), FIELDSTR(‘ProductName’)) will return
Red Jumper
Green Jumper
Red Shirt
Green Shirt
Blue Jeans
Black Jeans
CONCAT(FIELDSTR(‘ProductName’)‘, ‘available in ‘, FIELDSTR(‘Product Colour’)) will return
Jumper available in Red
Jumper available in Green
Shirt available in Red
Shirt available in Green
Jeans available in Blue
Jeans available in Black