Advanced sort on hyperlink column is incorrect

[Former Member]

HI

  I have a column and sorted by advanced custom order. In result i got the correct result, if i add hyperlink to that column then sort option changed to default ascending order.

How to retain the custom order even though hyperlink is applied. I tried added one more column beside then sorted and hide it but still if i apply hyperlink again it is changed to ascending order.

[arijit_das · Accepted solution]

After adding hyperlink, the formula for the column changes. So you need to create a variable with that formula and apply custom sort again on that variable.

[Former Member · Accepted solution]

Hi

  For which formula, i need to create variable? whether field used in hyperlink or whole hyperlink?

[arijit_das · Accepted solution]

formula for the whole hyperlink

[Former Member · Accepted solution]

HI I have did the same and i can able to sort but if i change the prompt values then variable producing another set of values for hyperlink and again sorting issue.

[sateesh_kumar1 · Accepted solution]

Hi ,

Custom sort does not resets with the values of objects . Apply custom sort to only values which will not change over time .If there is any business logic to custom sort , generate a flag and sort on that .

Ex : If [Object]="America";1;if [Object]="Asia";2;if [Object]="Africa";3 ..Now sort on 1 ,2,3 not on Object.

[former_member201488 · Accepted solution]

This is one reason why I use Alerters for hyperlinks - the underlying data remains unchanged, but you can amend the alerter as much as you like without affecting the data.

HTH

NMG

[Former Member · Accepted solution]

Hi

  As you said, i created a column with 1,2 & 3 values. Now i have one column which has hyperlink and another column (1,2 & 3) values. If i sort the 2nd column by ascending again it is not sorting because of hyperlink. Hyperlink sorting in ascending order.

I want to do custom sorting like start with B is first, P is second, G is third & E is 4th but this is not happening.

I couldn't find any solution.

[sateesh_kumar1 · Accepted solution]

HI ,

It is working properly .Do  you have any other sorts applied on table .If yes remove other sorts and try .