On a form we are using there are two fields. Field One shows the names of teams to which the person can belong (from a KeyWord List). Field Two offers the user choices from the first field, and indicates which of these teams this person heads. For example, Field One may show "Logistics" and "Personnel", while Field Two may show "Logistics". The person belongs to both teams, and is the head of the first.
Now the problem: I would like to create a view, categorized by teams, which shows all team members. However, I also would like to indicate which of the team members is the team head.
The difficulty I see is that when categorizing a view from a multivalue field eg., Field One), Notes does not seem to "know" which of the categorized values it is showing in (say) the first column. Thus, if I test for "head", the view would show this person as the head of BOTH teams! Help!
This can't be done directly in a view.
Dig Deeper on Domino Resources - Part 3
Related Q&A from Brian Mahoney
Find out what types of calculations can be computed for a column in a Lotus Notes view and the best way to go about it with this expert response. Continue Reading
Find out why you can't use Formula language to include a doclink to a specific Lotus Notes view or database and need to use LotusScript instead. Continue Reading
Discover the reasons behind a Notes/Domino admistrator having trouble with disabled options in the "customize this view" section of his Lotus Notes ... Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.