You are viewing limited content. For full access, please sign in.

Question

Question

How to sort content of multi-value field

asked on November 7, 2016

I have several multi-value fields on my template.  One of which is location, the other is user job title.  Both location and job title can have values added or deleted depending upon where the product is used or the training needs on a particular procedure.

With all the additions and deletions, it would be nice to be able to sort the remaining values in the multi-value field for easier Q/A.

Can the values in a multi-value field be sorted?  If so, how?

0 0

Answer

SELECTED ANSWER
replied on November 8, 2016 Show version history

Hi Michelle I think this is what you need.

01 Retrieve field values



02 Assing field values with replace 



03Here the result
  Before:



  After:





Hope this works for you and if you have any question we can look it.

Regards.
   
 

2 0

Replies

replied on November 7, 2016

Do you try use the function "Sort" 

Here an example:

01 First I create a multi value token

02 Assing values to the token


03 Sort by function


This is configured on token editor




This is the result 



Also work with Letters




Hope this work for you.
 

0 0
replied on November 8, 2016

David, this is wonderful solution for sorting the values in the field, but could this repopulate the template in the new order?

That's my real need, is to be able to provide the sort ability to users so that they can see the values of the multi-value field in order.  Because even if I can run a nightly workflow on thousands of documents to sort and repopulate these fields, that may not be timely enough for a user to identify the correct information in the field and not replicate it.

Thoughts?

0 0
SELECTED ANSWER
replied on November 8, 2016 Show version history

Hi Michelle I think this is what you need.

01 Retrieve field values



02 Assing field values with replace 



03Here the result
  Before:



  After:





Hope this works for you and if you have any question we can look it.

Regards.
   
 

2 0
replied on November 8, 2016

I will give that a try!  Thanks David!

0 0
replied on November 8, 2016

Sure !!

 

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.