Lotus Domino, LotusScript
I have a formula for @dbLookup, or @dbColumn, that results in a list that is too large, how can I word the formula to filter the list so that the results only contain MOMHP as the first 5 letters or the word- can I use it within the @dblookup formula? Thanks! 
0
0
0
Looking for relevant Lotus Domino Whitepapers? Visit the SearchDomino.com Research Library.
LoudSinger | Aug 23 2004 6:37PM GMT
To limit what is received, you must either limit the number of columns or rows, to a total of 64K. Alternatively you can use @Picklist with a view containing a single column with the value you need. The big advantage of @Picklist is that you avoid the 64K limitation. If you want to retrieve multiple values, put them into the specified column with a delimiter. For cosmetic purposes you will want to hide the retrieval column from view. The rest is a matter of formatting and sorting the visible part of the view so it presents the information you want.
THis solution assumes you are using the Notes client. FOr Web you can format a view with the rows as checkboxes or radio buttons, depending on your needs, and then embed this view in whatever form you want to access the information from.
