Subject: Still having problem fixing a view
Right, I forgot to take into account that this would result in multiple Activities.
Would this be acceptable, just incase the easier solution is good enough? Adding a second level of categorization?
v Montly Accomplishments
. . . . v May 2008
. . . . . . . . Document
. . . . v April 2008
. . . . . . . . Document
. . . . v March 2008
. . . . . . . . Document
v Activities
. . . . v May 2008
. . . . . . . . child
. . . . v April 2008
. . . . . . . . child
. . . . v March 2008
. . . . . . . . child
Eliminate Column 2,
Column 3 becomes: @If(Form = “Monthly”; “Monthly Accomplishments”; “Activities”)
Keep Column 4
New Column 5 would be Categorized and be: (Month + " " + Year)
I’m going to try another idea… Post more later.
Subject: RE: Still having problem fixing a view
OK, I confirmed what I expected (and repeated by Stan) to get what you want you’re going to have to change your value after the "Activities " to work with the alphabetic sorting. I don’t see a way around it.
Therefore you want to change the column to something like:
m := @Month(date);
mn := (“Jan”:“Feb”:“Mar”:“Apr”:“May”:“Jun”)[m];
mt := @Right(“0”+@Text(m);2);
y := @Text(@Year(date));
@If(Form=“Monthly”;“Monthly Activities”;"Accomplishments \ " + mt + ") " + mn + " " + y )
Which gives you:
The thing you need to remeber is it’s the column that is sorting the data and the entire thing is one string. So you can only sort things BEFORE or AFTER that column. I tried doing it before and that resulted in multiple “Accomplishments” Anything after is too late.
The only other work around is to break up the Accomplishments column but that will result in a new column inside of Montly Activities which was the other option I offered.
Subject: Still having problem fixing a view
Try putting a hidden column in - first column, most likely, w/ a date field- sort it descending- it should sort everything to the right of it. Now, if the children’s date field is a different name then the parent’s date field- bring the date in by form w/ an if statement-
Subject: RE: Still having problem fixing a view
If I understand your suggestion correctly, this is what I was trying to do.
The problem is “he” wants a single top level categorization after that sorting column, but this technique results in something that looks like this instead:
Subject: RE: Still having problem fixing a view
It’s the cascading category that will keep this forever out of reach. If the category isn’t cascaded, then the “Accomplishments” document type will wind up with a useless and confusing subcategory, but if it IS cascaded, there’s no way to get the months in proper order without winding up with multiple top-level “Activities” categories unless Renan is willing to forego the month names in favor of month numbers. “2008-03”, “2008-04” and “2008-05” will categorize properly without an artificial sorting column, but “March 2008”, “April 2008” and “May 2008” will not sort as desired, ever, with or without a separate sorting column.
Subject: Still having problem fixing a view
Please – if you’re posting from Notes, use doclinks instead of URLs. They’ll work on the web, and they’re a heck of a lot easier on the rest of us Notes users. Oh – there’s really no need for separate threads, either, since most of us tend to use the “flat” view and new entries in old threads will still appear at the top.
Would you believe that if you are sorting on an alphabetical representation of the dates, they will sort in alphabetical order? And that there’s not thing one you can do about it? (In your second example in the third link, the column is sorting descending rather than ascending, which gives the May, March, April ordering.)