Solved

sorting a field in Input Translation

Posted on 2004-09-28
6
200 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
[X]
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
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: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering 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

Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
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 a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

752 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