ValueListLookup Function

  • Updated

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".

Was this article helpful?

0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.