How to sort ?

Hello. how to sort in an increasing or decreasing direction?

- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Reported - view
It's because you used a text field for the numbers, if you use a number field it would be sorted right.

Steven
- Alain.1
- 3 yrs ago
- Reported - view
Thank you for your feedback, in fact the number is generated by this formula, which I copied on an example. How to explain that the number is in a "txt" format?
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Reported - view
Text fields are always left aligned, and number fields are right aligned. Fast solving the problem: You can use a formula field where you put the formula:

number('N°') (<this makes a number of your text field)

and then display that column in your table view and order by this column.

Let us know how it goes and if you need further help, don't hesitate to ask.

ps: also check this tread: https://ninox.com/en/forum/use-cases-5abd0b9c4da2d77b6ebfa395/create-tables-with-autonumbering-with-ease.-5d5ee82ab6ba1f2dab0664b4

Steven
- Alain.1
- 3 yrs ago
- Reported - view
Ok i will try. Thanks

Content aside