How to show 10 points rating scale the right order
I want to get a session feedback from customers using a lookup of a scale 1-10.
I created the lookup writing the numbers on a text field (because lookups require a text field only for the display field), there for it shows the lookup the wrong order:
1,10,2,3,4,5,6,7,8,9. (The 10 is between the 1 and the 2).
Any ideas of how to force it displaying the right order?
(I tried adding a value field to the lookup of type integer but can't find a way to sort it using that field.)