Forum Academy Marketplace Showcase Pricing Features

RG Sorting issue

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.


image
image

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

Cheers,
Ranjit | Blur Apps

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?

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