Lotus Notes View with categorization on one field but sorted on another

15 pts.
Tags:
Lotus Notes
Lotus Notes View
Hello, I have a lotus notes view that is categorized by author name. Each author has several composed forms, with each form receiving a score. I need to show the "top scorers". So I need a view that will sort the cumulative scores of the authors by highest cumulative score to lowest.
ASKED: March 1, 2009  5:55 AM
UPDATED: June 21, 2010  5:25 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

I don’t see what version of Notes you are on. Unless there is a new function for this in R7 or R8 that I do not know, there is no way to do this with your existing design. You will need to add a form to lookup and calculate the cumulative scores, then use that form to provide the view that will sort the cumulative scores of the authors highest to lowest. You will also need a scheduled agent to update these values on a regular basis, and create a document when someone new starts getting scores on the system.

I’ve create summary forms like this on a few occassions.

However, I would also review your other reporting needs to determine whether you should be developing a reporting tool to compliment the Notes application(s), then include this report in that system, instead of trying to build this reporting function into Notes.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • GQbed
    Perfect. Creating the form and creating a view from the form worked. Thanks!
    15 pointsBadges:
    report
  • Steel628
    hi.. can u send me a sample agent for this. i really need this. thanks very much
    20 pointsBadges:
    report
  • Steel628
    send to me via email or on this post. email is supermanreturns628@gmail.com
    20 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following