Hi, I'm trying to categorize a view based on two,three, maybe even four criteria. An example
would be pulling up Types = ('1','2','3') or maybe just Types = ('1','2'). I basically just need to
create a dynamic overlay of two different categories in a calendar.
OK, assuming you are working in a "normal" view, this should be easy: Assuming you have a
multi-value field, which you want translated into sub-categorized entries in a view (field "Types"
= "1":"2":"3"), and you want it to show: 1 2 3 doc1 doc2 doc3 This is easy: Put the following code
in a sorted, categorized column: @Implode(Types;"\") This will compress the multiple values into
one string value, and separate them with a backslash (). You've got to use double-backslashes in
@functions, though. Because the string will then be "123", Notes views have a little-known property
that, when they are categorized and the column contains these, they act like sub-category entries.
Handy, eh?
This was first published in November 2002