I am trying to use @dblookup to lookup a hidden view by date. I keep receiving an error message saying “server error; entry not found in index” Im not too sure if it is the date format. The first column in the hidden view is sorted and is in date format. My form where I put @DbLookup(“” : “NoCache”; “”; “Information View”; datecreated;“STR_53”) should take the date from the form and do the lookup by the date to retrieve the 2nd column from the hidden view.
Not sure if im making any sense, but any info is appreciated.
The first sorted column in the view should be the date column
You should always look for data in the same format as it is displayed in the view; i.e. if the view is displaying dates as strings, then you need to look for a string representation of the value datecreated.
datecreated is actually an editable field using the calendar/time control option. I want the users to choose the date and let the @dblookup take it from there. Oh yes, I tried the columnNumber to 2, that wasnt working either, thats why I displayed the field name. Not too sure what else I can do.
the formula must first ensure that datecreated is not empty. try this:@if(datecreated != “”; @DbLookup(“” : “NoCache”; “”; “Information View”; datecreated;“STR_53”) ;“”)