Solved

Categorize by Adress book usernames in a view

Posted on 2004-08-05
2
297 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
2 Comments
 
LVL 46

Accepted Solution

by:
Sjef Bosman earned 80 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Mobile Iron iphone stop receiving new mails 6 1,228
Incorrect reply-to address Lotus 2 27
Disable Return Receipt In Lotus Notes 15 181
Installing Lotus Notes on Citrix XenApp 3 105
  In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
For beginners of Lotus Notes user this is important to know about the types of files and their location supported by IBM Notes. Mostly users are unaware about how many file types are created and what their usages are. This Article is fully dedicated…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

910 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now