Sign Up for Training |
Jet Global Company Site
Community
Downloads
Submit a Request
Give Feedback

NF Field Not Found in Field Cache


Overview

If you create an NF function referencing an NL function with a field cache you may get the error Field '[field name]' not found in Field Cache or Field '[field name]' is not in the provided field cache

Complete text of error message is:

Field '[field name]' not found in the Field Cache

or

Field '[field name]' is not in the provided field cache

Cause:

While the field in your NF() function may be present in the table, is not included in the list of fields being returned by the NL() function that your NF() function is referencing.


Resolution Process

  1. Modify your NL() function by ensuring that it either returns all available fields [if you table has a primary key, this is accomplished by list *no* field name in your NL() function] or that it returns all fields (in a field cache) that you need to reference with your NF() functions:

    A Field Cache may appear in an NL() function in 2 forms, either a comma delimited list of fields inside curly brackets: { "field1", "field2", "field3" } or a range of cell references: $B$2:$G$2. 

    To add another field to the Field Cache, either add a comma and then the name of the field in quotes to the end of the list inside the curly brackets (in the first case) or extend the cell range and type the name of the field into the last cell (in the second case).

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments