Sign Up for Training |
Jet Express Support |
Jet Reports Company Site
Jet Reports Financials
Jet Professional
Jet Enterprise
Submit a Request
Give Feedback

NF Field Not Found in Field Cache

Also seen as: "Field '[field name]' is not in the provided field cache"

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. You must add this field to the Field Cache in your NL function for the NF to work.  While the field in your NF function may be a valid field in the table, it is missing from the Field Cache in the NL function. A Field Cache is required for a table that has no primary key and is recommended even for a table with a primary key since it speeds up the report. For this reason, the Report Wizard and dragging and dropping from the Jet Designer always create field caches in the NL functions they create.


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