Solved

sorting a field in Input Translation

Posted on 2004-09-28
6
199 Views
Last Modified: 2013-12-18
Hi,
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.
thanks
Sridevi
0
Comment
Question by:sridevi911
  • 3
  • 2
6 Comments
 
LVL 14

Expert Comment

by:p_partha
ID: 12176326
Is it R6?

Partha
0
 
LVL 14

Accepted Solution

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

Partha
0
 

Author Comment

by:sridevi911
ID: 12176381
yes the client is 6.5.2.  

how in lotus script?
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:sridevi911
ID: 12176432
@sort works fine partha...

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

thanks
0
 

Author Comment

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

Assisted Solution

by:Sjef Bosman
Sjef Bosman earned 20 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.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying 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…
This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

685 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