Categorized columns and keywords ?

Hello experts,

I've a little problem.
I've made a form with 6 keyfields.
I want to search first the first field, then the second fields etc...
The problem is that sometimes only the first three fields are filled in.
So, when I go to my view, I see in  the fourth, fifth,.. column not categorized (all columns are categorized).
And if I want to open the document I must always go to the last column.
If there are only three fields filled in, I want see the document in the third column so if I click in the third column the document must go open.
Who has a good solution.
I'm working with R5 and it's an intranet application.

Thanks in advance.
Who is Participating?
Hello Magnex,

if the six columns are simple field values, than you can use this trick:
Crate only one column for all six values, make it categorized and with twisty.
For column formula enter this:

Good luck,

That was a good one!  But do you really need an Implode ?
I dont think so ! The trim itself would take care of it wont it ?
Hey Arun, what are you talking about? :-)

Now I understand why I still got no points for @Replace(:-))

Explain to me and to Magnex how do you plan to compose this string:


I hear nothing :-)

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

Oh Boy I was in the impression that all the values are found as separate categories and not one below the other.  If its tree structured as you suggest, then YES ! You are right on TARGET !!!

Sorry Arun,
Today I am ill and not so polite.
Forgive me please :)

You are of course right Arun: the categories where found in separate columns.
But with separate columns you can not suppress categories with empty values.

My trick is to make a single char first category. This category (in the first column) can expand up to six categories when values are separated by backslash character.
And for this backslash you can compose value by value with backslash in between, or, implode all values with the backslash as separator.

Do you see now the trick?

magnexAuthor Commented:
Zvonko and Arun, thanks for the help.
Zvonko, your solution works, but there's only one negative point, and that is that I've only categorized columns.
So, the line where I must click for open the document is blanc.
Is here also a solution for ?

Thanks for the help.
Jean Marie GeeraertsApplication EngineerCommented:
It's a trick I use in more than one application of mine :-)
It's simple, yet genious, don't you agree, zvonko ?

I'm just sorry I saw this question after you answered it :-)

This is one of my "Tips and tricks in Notes"

I am on vacations sitting at home. Just yesterday and today I am ill and have a temperature.

But to stand up and look into the box is possible in biggest fever :-)

to magnex: have you tested my proposal? Because there are enough pitfalls so you see no categories. Do you see categories with my formula? If not, then state here and we can help you getting them.

So long,

magnexAuthor Commented:
Thanks for the solution.
But last question, is it possible to give each field another color in the view.
Because you have know only one column, I think it's not possible anymore.
Thank you for the points :-)

Yes, it is possible, but I would not recommend it to you.
In Notes client it is not possible, but for Intranet, as in your case, you can embed <font color> tags.

I would like to put your attention to another pitfall: if the second and fourth values of your six fields are empty, then you see only the last two categories disappear. You see the problem?


Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.