Search DominoPower's 11,443 Lotus-related article archive 
Home
EasyPrint
News details Click here for the RSS feed's XML code. This is not a browser URL.
Articles-only Click here for the RSS feed's XML code. This is not a browser URL.
Twitter Feed Click here for the Twitter feed.
DESIGNING FOR THE INTERNET
Sorting documents via Notes and the Web
By Dan Velasco

What are your 25 top favorite movies? Can you name them? Can you print out a list of them? Can you sort them easily by using either a Notes client or a Web browser?

This is the challenge that I gave myself recently. I wanted to keep track of my own list of favorite movies and be able to easily sort that list and add to it at any time. If you're already in the Notes frame of mind, you're beginning to realize that there is really only one way to sort information like this: assign a numeric value to each of the items and then begin a-rankin'.

The problem with just going off and ranking the items is that you really don't have an easy way of keeping everything in order. Once you populate all the numbers, say from 1 to 25, you then run into the problem of trying to easily re-sort the list. Every change you make to one document's sort number requires you change another document's sort number. You could just manually change the sort number on each of the forms until everything was ordered just right. Of course, if that option appeals to you, you might as well just invite all the folks over for a barn-raising because you're officially Amish, my friend.

This was definitely a job for LotusScript.

A Simple Plan
The basic concept is simple. First, on each of the documents you want to sort, you should create a numeric field called Sort_Number and, if you want to sort documents within a category, an optional text field called Sort_Category. If you want to move a document up, for instance, you need to reduce the existing sort number by one, say from 3 to 2. Then you need to find any document that has the same sort number as the changed document and increase it by one, say from 2 to 3. Basically, you're switching the sort numbers of two documents.

You may be wondering why we're numerically sorting documents in this fashion? The simple answer is that this is useful if items require subjective ranking. Not everything has an obvious field by which to sort it. Take, for instance, a collection of documents that contain pictures of your company's party. You want people to be able to scroll through a view that displays all of these pictures in a Domino view. The best way to order these pictures would be to assign a sort number to each and then rank them amongst themselves until it pleases you. This is an ideal example of the type of sorting I outline in this article.


1  ·  2  ·  3  ·  4  ·  Next »
Other articles you might like
Home > Lotus Technologies > Notes (84 articles)
   A walk down Memory Lane with Lotus Notes
   An application for scanning physical mail and distributing it virtually
   Managing Notes deployments with Teamstudio Build Manager
Home > Lotus Technologies > LotusScript (64 articles)
   When the debugger won't debug hidden code that isn't hidden
   What to do if the LotusScript debugger won't single-step over code
   Little known traps about Lotus Notes fields
Home > Tips & Techniques (102 articles)
   More about Domino log files
   Why your log.nsf might not be purging properly
   A faster way to repair corrupted server files
Home > Lotus Technologies > Application Development (48 articles)
   An application for scanning physical mail and distributing it virtually
   How hide-whens in Rich Text can ruin your whole day (and what to do about it)
   Little known traps about Lotus Notes fields
Get Weekly Email Updates
Subscribe to our regular weekly email newsletter. It's packed with tips, reviews, deep analysis, and the latest news.
 
Recent DominoPower Articles
Syncing Notes with Android phones
Application development, William Shatner, and the origin of the universe
Learn Domino Designer 8.5 for free
The (near) future of Sametime, Quickr, Connections, and Symphony
Inside the IBM Innovations lab
Lotusphere 2010: Hot fixes and cool news for Notes, Domino, and LotusLive
Lotusphere 2010: mobility and collaboration
Latest Lotus Headlines
Xpages not loading? JVM errors? - Solution
How to implement an iCalendar feed into your Notes calendar with XPages
DWA Hotfixes for Domino 8.5.1FP1 - A Gotcha
IBM Adds DB2 to Lotus Foundations SMB Package
SNTT : XPages onclick Ghosts in the machine
Ports used by Lotus Sametime 8.5 servers
Exploring a Domino Date Bug
>> Read all the news
More from the ZATZ journals
Computing Unplugged: Online safety for virtual learning
David Gewirtz Online: CNN commentary and analysis
OutlookPower: Seek and find: Strategies to locate filed-away emails fast
-- Advertisement --

Learn Notes and Domino 8 at your place and pace!
Learn Notes and Domino in your office and/or home! TLCC's highly acclaimed distance learning courses for users, developers, and admins will enhance your career and your resume.

The many included activities and demos will make you a pro! Expert instructor help is a click away.

Click here to try a FREE demo course!!

-- Advertisement --

Struggling with exporting Notes data to spreadsheets? No More!
Try IntelliPRINT, The world's leading Reporting, Dashboards, and Analysis solution for Notes & Domino

  • Don't spend unproductive time maintaining different versions of the same spreadsheet
  • Preserve data integrity and security in multi-user environments
  • Create reports in minutes INSIDE Notes
  • Get freedom from iterative report requests, deliver self-serve capabilities

Experience Reporting, Dashboards, and Analysis INSIDE Notes.

Try IntelliPRINT NOW!

ZATZ Home  ·  News  ·  Back Issues  ·  Credits/Trademarks ·  Link To Us
Copyright © 1998-2010, ZATZ Publishing. All rights reserved worldwide.
Editor's Login