Table of Contents
Overview
This Custom Field creates a list of unique values based on a set of parameters.
Syntax
DISTINCTLIST(‘,‘, FIELDSTR(Field A), FIELDSTR(Field B))
| Element | Description |
|---|---|
| Separator | The delimiter separating the values |
| FIELDSTR(Field A) | String contents |
Example
1. For the table
| Shape |
| Round |
| Round |
| Square |
DISTINCTLIST(‘,‘, FIELDSTR(Shape A), FIELDSTR(Shape B), FIELDSTR(Shape C))
will return
Round, Square
2. For the table
| Shape |
| Round |
| Triangular |
| Square |
| Triangular |
| Round |
DISTINCTLIST(‘;‘, FIELDSTR(Shape A), FIELDSTR(Shape B), FIELDSTR(Shape C), FIELDSTR(Shape D),FIELDSTR(Shape E))
will return
Round; Triangular; Square