Hi everybody,
This is for Notes Client.
In one db, I have parent and children documents.
The parent docs are called “Monthly Accomplishments” and the children “Activities”.
The user wants the view as shown below, so I’m not showing the “Response documents in a hierarchy”.
Also, he wants the docs categorized and sorted in descending order by month.
The view shows records for March, April and May.
Both parent and children docs have a hidden field (MonthID) that records the number of the month (showed in the view in RED).
The formula to categorize parent and children, by month, is:
@If(Form = “f.parent”; “Monthly Accomplishments”; “Activities” + “\” + Month + " " + Year)
Then there’s a hidden column that picks up the number of the month and the next column shows the Month and Year of the parent doc (if it’s the main doc) or the activity name (if it’s a child doc).
The problem is that ONLY the parent records are shown in descending order.
Does anybody have any solution for that?
TIA,
Renan