: 4582 | 108638 | 12353

Add sort as numeric to view column properties 
New idea submissions, commenting and voting are no longer available on this site. Logins have also been disabled.
Use this IdeaSpace to post ideas about Domino Designer.

: 5
: 10
: 5
: Domino Designer
: notes, views, sorting
: Fred Husoy740 05 Dec 2010
: / Email
In view columns you have option to check sort options to Case-sensitive sorting and Accent-sensitive sorting. I would like an additional option to sort as numeric.
This to avoid problems in sorting of numbers stored as text. Today, when stored as text 2000 comes before 201, and 200.13 comes before 200.2.
There are ways to avoid this by adding hidden columns, but this generates other problems regarding type ahead searching in the view. It would therefore be really nice to have this as an option for the view column. Alternatively Numeric could be added as type of content for the view column.

1) Johannes Madsen344 (06 Dec 2010)
Why not simply replace Column_Formula with @TextToNumber(Column_Formula)?
That's what I do
2) Peter Presnell26659 (10 Dec 2010)
I think you are adding an unnecessary layer of complexity to the design element to solve what is really bad application design. Don't store numbers as text if they really should be treated as numbers. Go to the place where the data is being created (e.g. Form) and add the logic to ensure a numeric value is being stored. This can even be in a second (computed) field if the original format needs to be preserved.


Welcome to IdeaJam™

You can run IdeaJam™ in your company. It's easy to install, setup and customize. Your employees, partners and customers will immediately see results.

Use IdeaJam to:

  • Collect ideas from employees
  • Solicit feedback and suggestions from employees and customers
  • Run innovation contests and competitions
  • Validate concepts
  • Use the power of "crowd-sourcing" to rank ideas and allow the best ideas to rise to the top

IdeaJam™ works with:

  • IBM Connections
  • IBM Lotus Quickr
  • Blogs and Wikis
  • Websphere Portal
  • Microsoft Sharepoint
  • and other applications.

IdeaJam has an extensive set of widgets and API's that allow you to extend and integrate IdeaJam™ with other applications.

Learn more about IdeaJam >>

Use more customization features in ND9 NotesMail
Two-week Calendar view
@Formula library
Drafts - unsent count?
New Hide-When property
Activity Logging for Quickr
"follow-up complete" flag
Remake Resource Reservation template using XPage
Boolean operators on LDAP group based access control
Store IP Address / remote host data in Password Lockout documents
Checking Out-Of-Office status of others
Tool to show unreferenced design elements for easy cleaup
Bring sametime audio and video into the web browser using WebRTC
"Window Title" for views
QuickR application/widgets for Android/iPhone
Create Computed Text with the same text style as the current paragraph
@Function and LotusScript to "View..Customize This View" dialog
Extend the 'User detail' info of a database
Print of calendar in color
Shared Actions belong under Shared Elements
Facelift all web enabled templates with xPages
Please extend WebDAV to include calDAV & cardDAV support for contacts/calendar syncing
Skin-ing Notes Design elemens
Add some views into the "Views" section of the Notes 8.5 mailbox

IdeaJam developed by

Elguji Software Logo