XListValue
Returns the value of a field in an external list.
Syntax
XListValue(listName, primaryKey, fieldName)ReadXListValue(listName, primaryKey, fieldName)
listName = name of the external list
primaryKey = value of the primary key identifying the row whose value you want to read
fieldName = name of the field whose value you want to retrieve from the list
Remarks
This function's parameters are case-sensitive. Returns #ERR! in the event of an error.
Example
For the following list, named Items:
| Code (primaryKey) | Description | Price | Unit of sale |
| Wheel | Bicycle wheel | 25 | 1 |
| Screw5x45Ph | 5 x 45 Phillips-head screw | 4.30 | 50 |
XListValue("Items", "Screw5x45Ph", "Price") = "4.30"XListValue("Items", "Wheel", "Description") = "Bicycle wheel"
XListValue("items", "Screw5x45Ph", "Price") = #ERR! because "item" not found (incorrect case)XListValue("Items", "Screw5x45Ph", "price") = #ERR! because 'price' field not found (incorrect case)XListValue("Items", "Screw12x45", "Price") = #ERR! because the primary key does not exist