• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 210
  • Last Modified:

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
0
sridevi911
Asked:
sridevi911
  • 3
  • 2
2 Solutions
 
p_parthaCommented:
Is it R6?

Partha
0
 
p_parthaCommented:
you can use @sort if it is r6, otherwise you might end up using lotusscript and doa  sort

Partha
0
 
sridevi911Author Commented:
yes the client is 6.5.2.  

how in lotus script?
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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 BosmanGroupware 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

Featured Post

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.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now