Sorting column in web

HCL Domino Domino Forum
1

Hello all,

i have one view on web, we have one column that should be sorted ascending order.

we are having value like

“13”

“001”

“00100”

“14”

“15”

Note : above are string value; because the first value should be string"

but it should display like this.

13

14

15

001

00100

any suggestion?

Regards,

Dev

2

Subject: Sorting column in web

Have a hidden sorted column before your display column with this:

@TextToNumber(“1” + @text(yourField))

3

Subject: Sorting column in web

Have a hidden sorted column before your display column with this:

@TextToNumber(“1” + @text(yourField))

4

Subject: Sorting column in web

Yes, but honestly: This is really so basic, it should never be necessary to ask in this forum. Don’t your employers provide you with any kind of training? This will cost them a lot of money in the long run.

Copy the column, and paste it before the original column. Turn of sorting for the original column. Change your column formula from

to @ToNumber()

and finally hide the new column.

5

Subject: RE: Sorting column in web

Ironically That wont work, it would remove the leading zeros. see my post below

6

Subject: RE: Sorting column in web

Ironically That wont work, it would remove the leading zeros. see my post below

7

Subject: RE: Sorting column in web

Sorry, didn’t recognize that 001 should go below 15 (which does look pretty weired to me).

Looks like I missed the whole point.