[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 217
  • Last Modified:

View Hierarchy - Non-alphabetical sort

Hi all-
I would like to create a view that allows me to control how I want a field value sorted.  
The specific example is that I have a field that indicates the importance of a form.

The available values are:
Urgent
High
Medium
Low

I would like to sort it this way, but every time I create a view, it defaults to sorting it alphabetical, like this:

High
Low
Medium
Urgent

I would like to be able to reverse the sort too.

Thanks for your help!
0
Aquilon7
Asked:
Aquilon7
1 Solution
 
HappyFunBallCommented:
In a column to the left of the category, put in this formula:

@Member(CATEGORYFIELDNAME; "Urgent":"High":"Medium":"Low");

Enter your category field in place of CATEGORYFIELDNAME

Also set the column to sort ascending.  The function will return 1 for Urgent, 2 for High, etc...
0
 
Sjef BosmanGroupware ConsultantCommented:
Insert a hidden column, sorted ascending, just to the left of your column, with a translation formula, like
    @Replace(Priority; "Urgent":"High":"Medium":"Low"; "A":"B":"C":"D")

You can unsort your column then.
0
 
p_parthaCommented:
Cool tip HappyFunBall !

Partha
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

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