Forum Discussion

MichaelTamoush's avatar
MichaelTamoush
Qrew Captain
6 years ago

Order of numbers

Quickbase (like pretty much everything relating to computers) orders numbers like so:

1
10
11
12
2
3
4
etc...

So if I have something labeled Truck 1, Truck 2, Truck 3.....and try to sort by that field, the sort is always 'out of order'.

I understand why it is doing that, but is there a work around, or just bad practice to name anything in this way?

------------------------------
Mike Tamoush
------------------------------
  • You would need to either number you Trucks like
    Truck 01
    Truck 02
    Truck 03


    Truck 10

     or else make a formula field to make a new field which would put in that extra 0 for sort purposes.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    markshnier2@gmail.com
    ------------------------------