Have you ever faced the problem with multi-valued fields that are related to one another and tried to show them sorted in a view? For example, Field 1 selections drive Field 2 selections and both hold multiple values.
expected result
Org Name Person Name E-Mail Address
------------------------------------------------------
Abc Company
------------------Jone
--------------------------jone@abc.com
BBC
------------------kevin
--------------------------kevin@bbc.com
actual shown
Org Name Person Name E-Mail Address
------------------------------------------------------
Abc Company
------------------Jone
--------------------------jone@abc.com
------------------kevin
--------------------------kevin@bbc.com
BBC
------------------Jone
--------------------------jone@abc.com
------------------kevin
--------------------------kevin@bbc.com
SOLUTION
Create a new field on the form and name it CATEGORIES. This can be a multi-valued field with NL as separator. Make it a combination so that the field value appears like this:
CompanyJoneJone@abc.com
BBCKevinKevin@bbc.com
Your view the first column has to be categorized and it has to look up this CATEGORIES field. Preview in Notes and I guess this should work fine. I have just done something like this.
If the preview does not work, first try SHIFT+F9 to rebuild the view index. If that does not work try selecting one document in the view and use Actions --> Categorize. If it shows you an empty prompt, type in BBCKevenKeven@bbc.com and then do the SHIFT+F9. This will change the value in the categories field. But since that is a computed field, open the document and refresh it again and you should be in business.
Do you have comments on this tip? Let us know.
This tip was submitted to the SearchDomino.com tip library by member Prashul Kumar. Please let others know how useful it is via the rating scale below. Do you have a useful Lotus Notes, Domino, Workplace or WebSphere tip or code snippet to share? Submit it to our monthly tip contest and you could win a prize.
