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.)



Like 0



Hello Chani,

This doesn't answer your questions directly about sorting the lookup differently, however, I did want to mention I've been using emoticons in lookups for this purpose. They look nice and they do sort as expected.…

Using star emoticons, as I do in the article above, likely would be too confusing for values 1-10, but you could use number emoticons 1️⃣ 2️⃣ 3️⃣ … 9️⃣ 🔟 as well, which I believe  would sort correctly. Just throwing out an idea that is easy to implement.


Ryan Farley,

Thank you!

I ended up just labeling the values like this: 01,02,03,04,05...10

Thanks for letting me know about the emoticons, I might use it in a different place. 

Show all comments