Manage Learn to apply best practices and optimize your operations.

Error Check "Use Formula For Choices" In Keyword Field

When you make frequent use of the "Use formula for choices" option in keyword
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)

Dig Deeper on Lotus Notes Domino Administration Tools

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.




  • iSeries tutorials's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...