Breadcrumbs

Integration Suite | Formula | INTERNALVLSTVAL

Description

This formula retrieves a specific value type, such as an ID or external key, from a valuerange entry.

Formula(s)

{=INTERNALVLSTVAL(Attribute;Value type)}

Result

Array

Parameters

Parameter
Content
Format
Default value
Explanation

Attribute

Attribute ID or attribute name

Attribute ID: Integer

Attribute name: String



Value type

Value type to be read from the valuerange

Integer

VALUE_FORMATTED

Possible values:

  • VALUE_ID: ID of the valuerange entry

  • VALUE_FORMATTED: Formatted value of the valuerange entry

  • VALUE_UNFORMATTED: Unformatted value of the valuerange entry

  • VALUE_EXTERNALKEY: External key of the valuerange entry

  • VALUE_INTERNALKEY: Internal key of the valuerange entry