0

How to sort ?

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

4 replies

null
    • Ninox partner
    • RoSoft_Steven.1
    • 2 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
    • 2 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
    • 2 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
    • 2 yrs ago
    • Reported - view

    Ok i will try. Thanks

Content aside

  • 2 yrs agoLast active
  • 4Replies
  • 252Views