Table of Contents
Overview
This Custom Field finds the given key in a list of key/value pairs and returns the matching value.
Syntax
CASE(FIELDSTR(value),1,ABC,2,DEF,3,GHI)
| Element | Description |
|---|---|
| Text | Text to search |
| Key | Key to search for |
| Value | Matching Value |
Example
CASE(2,1,ABC,2,DEF,3,GHI) returns DEF.