?
Solved

Categorize by Adress book usernames in a view

Posted on 2004-08-05
2
Medium Priority
?
307 Views
Last Modified: 2013-12-18
Hi!

Me again...

I've got 6 fields in a form.  Each of these 6 fields can contain MULTIPLES of the adress dialog list entries.

I want to have a view which I could order by EACH names of the adress book entries entered in those 6 fields...

Example:  Field1 got 2 adress book entries, and Field2 got 2 other adress book entries.

In the view, I'd like to categorize according to the 4 different Adress book entries (so, even if the view would show 4 "twisties", they would list twice the 2 same documents, but it's ok)

Am I clear enough??  Hope so...

What I did so far was to add a hidden field in the form, which is filled with all the content of the 6 fields concatenated on the Save button.  I've put this field as Text, but even if I put it as Dialog list - Multiple Adress book, it dont work better!

Then I try to categorize a column in the view, telling to seperate values with semicolons (same separator as indicated in the 6 multiple value Adress fields of the form)
0
Comment
Question by:barbotte
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 46

Accepted Solution

by:
Sjef Bosman earned 320 total points
ID: 11731130
Try to use the following formula in the first (categorized) column:
    @unique(@trim(field1:field2:field3:field4:field5:field6))
0
 

Author Comment

by:barbotte
ID: 11735082
Works perfectly!  Thank you!
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Lack of Storage capacity is a common problem that exists in every field of life. Here we are taking the case of Lotus Notes Emails, as we all know that we are totally depend on e-communication i.e. Emails. This article is fully dedicated to resolvin…
Article by: Rob
Notes 8.5 Archiving Steps and Tips This article covers setting up a Notes archive, and helps understand some of the menu choices making setting up and maintaining a Notes archive file easier.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question