Please, help on fixing view

HCL Domino Domino Forum
1

Hi everyone,

Posted this yesterday => http://www-10.lotus.com/ldd/nd6forum.nsf/DateAllThreadedweb/66e7da4678a2dadd8525741c004942dc?OpenDocument

Any ideas please?

Thank you

2

Subject: Please, help on fixing view

I believe the problem is your column formula:

@If(Form = “f.parent”; “Monthly Accomplishments”; “Activities” + “\” + Month + " " + Year)

While you look at the view and it appears the MonthID is before the Month + " " Year, it’s actually after. Therefore

Activities \ April 2008

Activities \ March 2008

and

Activities \ May 2008

ARE in the correct order.

A simple fix would be to append the month ID in front of the Month Name (because of October - November and December you want two digits in all cases)

@If(Form = “f.parent”; “Monthly Accomplishments”; “Activities” + “\” + @Right(“0” + @Text(MonthID); 2) + " " + Month + " " + Year)

You would now get:

Activities \ 03 March 2008

Activities \ 04 April 2008

and

Activities \ 05 May 2008

If you don’t want it to be like this then have a hidden column before 1, that determines the order:

@If(Form = “f.parent”; “Monthly Accomplishments”; “Activities” + @right(“0”+@Text(Month);2) + Year)

I guess you already have some sort of column at the start as you have Monthly Accomplishements before Activites, so the new hidden column would have to go after that.

3

Subject: RE: Please, help on fixing view

Hi Stephen,

Thank you for your patience and suggestion. It ALMOST worked.

I’ve been trying to fix it by myself, but no success.

Can you help me out there?

Here is what I did:

Column 1: @If(Form = “Monthly”; 50; 10)
Column 2: @If(Form = “Monthly”; “Monthly”; @Right(“0” + @Text(MonthID); 2) + Year))

Column 3: @If(Form = “Monthly”; “Monthly Accomplishments”; “Activities” + “\” + Month + " " + Year)

Column 4: MonthId

Column 5: never mind

This view is almost perfect, except that it categorizes “Activities” three times. It should appear only once (as showed in the previous post) and below it, May 2008, April 2008 and March 2008.

If I change place columns 2 and 3, I get the view below, which is the one that I want to, except for the months under activities that again are showed out of order (May, March and April, instead of May, April and March)

What am I missing?

Thanks once again,

Renan