RG Sorting issue

[klobassimon]

Hi everyone

Needs some help with a sorting feature:

My RG is going 1, 10, 11, 12, 2 ,3 etc

I need to have the database set as text to enable user to input non numerical floors, eg G or LG

Any idea how to get it to sort numerically otherwise I may need to put a ‘sort’ row in which i’d prefer not to do.

[blurapps]

Is the number being displayed the Unit?
In that case you should sort by that parameter and mark descending.

Cheers,
Ranjit | Blur Apps

[andrewgassen]

I have this setup in one of my projects. I ended up creating a field called Sorting Index and it works perfectly fine. You mentioned you don’t want to do that…any specific reason why?

[klobassimon]

Hey @andrewgassen
Did you have the the sorting index field as an additional input for the user?