Skip to main content
Question

Order of numbers


Forum|alt.badge.img+14
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
------------------------------

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------