0

Sorting Problem

Hi

There was a problem sorting into a table

Format for display in the table text + Number

the same problem in dynamic selection formula for display 'Machine Room'.'Slot Machine2' order by 'index'

Has anyone encountered this? Please suggest solutions

3 replies

null
    • Fred
    • 2 wk ago
    • Reported - view

    That is not a bug. When you mix text and numbers it is treated as text, so when you sort text you do it one letter/number at a time. That means there is no such thing as 10's or 100's. You start sorting with the first letter/number which is A. Then you sort by the second letter/number which is 1, so all records with A1 in it are pulled to the top. Like it would be if you had AB, ABC, ABD, ABE, AC. All AB would sort before AC.

    The work around would be to put a zero in front of single digit numbers (01, 02, 03, etc). or if you are going into the hundreds then two zeros. Then it will sort "numerically".

      • iliper LTD
      • iliper_LTD
      • 2 wk ago
      • Reported - view

       Good evening , when I write 01 in the numeric field, it automatically turns into 1

      • Fred
      • 2 wk ago
      • Reported - view

      That is true. You have to do it in your code that puts the text and number fields together.

Content aside

  • 2 wk agoLast active
  • 3Replies
  • 17Views
  • 2 Following