One column in view from 3 fields

HCL Domino Domino Forum
1

Hello All

can some one please advise me,

I have a form with three fields (course 1, course2, course3)

I want to make a catagorized view … view by course. but how can I make the fields to be selected from ALL three fields, not just set colomn to field “course 1” for example?

Is there a way?

Many thanks

Jenny

2

Subject: one column in view from 3 fields

Hi Jennifer,

In the first column of your view put this formula: course1:course2:course3

In column propertie, second tab (sorting) set type - castegorized and select show multiple values as separate entries.

That’s it

Best Regards,

Dima Pechersky

3

Subject: RE: one column in view from 3 fields

Thank you Dima,Your advice works, I get the courses in seperate catagories like I wanted. But Because I have sometimes null in some course fields, I am getting an extra catagory (not catagorized) how can I get discard the fields where course in NULL.

Thanks alot,

Jenny

4

Subject: I Got It!

In place of course1: course2: course3

I put :

@If(course2 != “”; course2;course1) :

@If(course3 != “”; course3;course1) :

course1

Since for sure course1 will have some value in every form.

This way I don’t get a catagory for the null values.

I hope this is useful to anyone else.

Thanks

Jenny

5

Subject: RE: I Got It!

Hi Jenny,

I’m glad that it’s helped. To ignore null categories just use trimming:

@Trim(course1:course2:course3)

Dima

6

Subject: RE: I Got It!

Thanks again, I tried also what you gave me and it works perfectly . thanks