Lookup in Lotus Notes

10 pts.
Tags:
Lotus Forms
Lotus Notes
Hi, I have a form in lotus, where the user has to select their location from a field. I have a view set up with keywords e.g. Manager, Currency etc. When the user clicks on a fields e.g Manager on the notes form, I want them to see a drop down list which is in the keywords section, but needs to be based on their location. At the moment I am using a DB lookup but this doesnt' seem to work. E.g. User select Australia as location. In Keywords view setup is: Column 1: Manager - Column 2: Australia - Column3: List of Managers. Please help.
ASKED: August 29, 2008  3:41 PM
UPDATED: September 2, 2008  1:27 PM

Answer Wiki

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

If you want the keyword to work based on thier location, I would think the first column should be location, not manager. The second column should be manager. I assume you either have a separate document for each manager that includes his/her location and are categorizing the view on location (first column), then displaying the manager field (second column) or have one document with a location field and a multivalue field for manager name and that is being displayed in the second column.

In any case, this code should work as the formula for the manager lookup on the form.

In the Choices section of the Field Properties box, choose Use Formula for choices. Enter this forumula.

@DbLookup(“”:”NoCache”;”":”";”ManagerByLocation”;Location;2)

ManagerByLocation is the name of your view.
Location is the name of the location field.

In the Location field, in the Options section of the Field Properties box, select Refresh Fields On Keyword Change. This will make the Manager field refresh choices if the user changes the Location.

Added bonus:

Put this in the Translation formula of the Manager field. If there is only one manager for the selected location, it will automatically fill in. If the current manager selection for the current location is no longer valid, the Manager field will be blanked out.

Choices := @DbLookup(“”:”NoCache”;”":”";”ManagerByLocation”;Location;2);
@If(@Elements(Choices) = 1; Choices;
Manager != “” & @IsNotMember(Manager; Choices); “”;
Manager)

Discuss This Question:  

 
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

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