Option for natural sort order of numbers

[nxpet]

Hi, today all numbers are sorted "alphabetically", which results in sort orders like this: 1,10,11,12,2,3,4,... See some examples here:

It would be good to sort numbers in natural sort order (1,2,3,4...,10,11,12) rather than alphabetically (1,10,11,12,2,3,4,...). Or let the user decide by providing an option in the client how to sort.

Regards

Timo

[KartikOak]

Hi,

      Can you please confirm if, in the second image, the field being used is a short text field for consuming numerical values - in that case, the sorting will always be alphabetical.

Can you also confirm the client version?

Thanks

Kartik

[khoppe]

@KartikOak  Problem is, that an Admin need to define a Field as at least "Short Text" to be able to use Values like "1.10"  (in words:  one point ten), cause such Numbering is not possible with a Field of Type  "Integer"  or  "Floating Point".

Especially for creating Values like  "1.10.1.4" (in words: one point ten point one point four) only short text can be used.

This Behaviour exist at least to Version 12.5.0.4, which is in use in our Company.