@dbLookup in a dialog list

5 pts.
Tags:
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!

Answer Wiki

Thanks. We'll let you know when a new response is added.

You can make a different view to access. One that is setup the way up the way you want it. Pull the data from that instead.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • LoudSinger
    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.
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following