sorting a field in Input Translation

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
sridevi911Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
p_parthaConnect With a Mentor Commented:
you can use @sort if it is r6, otherwise you might end up using lotusscript and doa  sort

Partha
0
 
p_parthaCommented:
Is it R6?

Partha
0
 
sridevi911Author Commented:
yes the client is 6.5.2.  

how in lotus script?
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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.

 
sridevi911Author Commented:
@sort works fine partha...

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

thanks
0
 
sridevi911Author Commented:
also not sure if @sort works for alphanumeric values
0
 
Sjef BosmanConnect With a Mentor Groupware ConsultantCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.