Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


sorting a field in Input Translation

Posted on 2004-09-28
Medium Priority
Last Modified: 2013-12-18
I've a multi-value field in a form. The field can contain many values. Each value is seperated by a comma.
Now when the user saves the document, I want all the values in the field to be sorted in an ascending order automatically.

I guess it has to be done in the field input translation.

Is this possible.
Please advise.
Question by:sridevi911
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
LVL 14

Expert Comment

ID: 12176326
Is it R6?

LVL 14

Accepted Solution

p_partha earned 120 total points
ID: 12176356
you can use @sort if it is r6, otherwise you might end up using lotusscript and doa  sort


Author Comment

ID: 12176381
yes the client is 6.5.2.  

how in lotus script?
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.


Author Comment

ID: 12176432
@sort works fine partha...

But the only constraint is that it always sorts in Ascending order. What If I want Descending?


Author Comment

ID: 12176457
also not sure if @sort works for alphanumeric values
LVL 46

Assisted Solution

by:Sjef Bosman
Sjef Bosman earned 80 total points
ID: 12177341
Read the Designer Help, under @Sort:

    @Sort(list; [order]; formula)

In your case, probably @Sort(values; [DESCENDING]) will do. Sort will work on text, number or date values.

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For users on the Lotus Notes 8 Standard client, this article provides information on checking the Java Heap size and adjusting it to half of your system RAM in attempt to get the Lotus Notes 8.x Standard client to run faster.  I've had to exercise t…
Article by: Rob
Notes 8.5 Archiving Steps and Tips This article covers setting up a Notes archive, and helps understand some of the menu choices making setting up and maintaining a Notes archive file easier.
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…

718 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question