ValueListLookup Function
Looks up a display name by value from a value list. If the value is not in the value list, null is returned unless a default value is specified.
Syntax 1
ValueListLookup(valueList, value)
Looks up a display name by value from a value list. If the value is not in the value list, null is returned unless a default value is specified.
Arguments
valueList ValueList - The valuelist to use.
value Any - The value to check.
Syntax 2
ValueListLookup(field, value)
Looks up a display name by value from a value list. If the value is not in the value list, null is returned unless a default value is specified.
Arguments
field Field - The field having the value list to use.
value Any - The value to check.
Syntax 3
ValueListLookup(valueList, value, defaultValue)
Looks up a display name by value from a value list. If the value is not in the value list, null is returned unless a default value is specified.
Arguments
valueList ValueList - The valuelist to use.
value Any - The value to check.
defaultValue Any - The default value if not found in list.
Syntax 4
ValueListLookup(field, value, defaultValue)
Looks up a display name by value from a value list. If the value is not in the value list, null is returned unless a default value is specified.
Arguments
field Field - The field having the value list to use.
value Any - The value to check.
defaultValue Any - The default value if not found in list.
Remarks
Example:
ValueListLookup(ValueList1, 1); // returns "a"
Example:
ValueListLookup(GetValueList(ValueList2, 8, 9), 1); // returns "a"
Example:
ValueListLookup(ValueList3, 1, "notfound"); // returns "notfound"