fields (with the dialog list option) you probably also hate the display of the
Notes error message "Entry not found in index" when the execution of the
formula is erroneous or displaying a blank keyword dialog list when the formula
gets blank return values.
So here is a nice and simple way for displaying a sensible message in the
dialog list when this happens.
As the space in a keyword dialog list per line is limited, the key thing here
is to provide the message to the keyword dialog list in a multivalue way (see
definition of msg in the sample code below). It takes some trial and error to
get the right length of the message parts, but after that it looks a lot better
and makes more sense to the user than the good old "Entry not found in index".
server := "";
database := "";
view := "luKeywords";
key := "Product Type";
msg := "No keywords found." : "Please contact the database owner" : "(see about
document)" : "or check the keyword tables.";
list := @DbLookup("Notes":"NoCache"; server : database; view; key; 2);
@If(@IsError(list) | list = ""; msg ; list)