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
|
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. |
|
ValueListLookup(valueList, value) |
|
Arguments: |
|
|
valueList |
ValueList - The valuelist to use. |
|
|
value |
Any - The value to check. |
Syntax 2
|
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. |
|
ValueListLookup(field, value) |
|
Arguments: |
|
|
field |
Field - The field having the value list to use. |
|
|
value |
Any - The value to check. |
Syntax 3
|
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. |
|
ValueListLookup(valueList, value, defaultValue) |
|
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
|
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. |
|
ValueListLookup(field, value, defaultValue) |
|
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".
Comments
0 comments
Please sign in to leave a comment.