Stringfunctions+ | Formula MAPVAL
Description
If values are to be used differently in various contexts, this formula can be used for defining which value is to be used for which context.
Formula(s)
PHP
{=MAPVAL("Key";"Context";"ReturnKey")}Result
Array
Parameters
Parameter | Content | Format | Default value | Explanation |
|---|---|---|---|---|
Key | External key of the mapping | String | Create under Mappings | |
Context | Context of the mapping | String | ““ | Create under Context |
ReturnKey | Optional: Fallback value | Boolean String | FALSE | Default value as last parameter (e.g. ATTRVAL formula on original value to be able to use a fallback value if mappings are missing) |