If you use a Text field for sorting, records will be sorted in order of UTF-8 character codes.
For this reason, if your Text field contains numbers equal to or greater than 10, records may not be listed in the order you expect.

For example, when sorting records in ascending order, values may appear as follows.
"1", "10", "11", ... "2", "3"

To resolve such an issue, use one of the following methods.

• If the field contains both one-digit and two-digit numbers (e.g., for expressing a month), add "0" at the beginning of the one-digit numbers.
  Example: 01, 02, ... 10, 11, 12
  
  

• Use a Drop-down field instead of a Text field.
  With a Drop-down field, records will be sorted in the order that you have configured under Options in the field settings. You can make sure records are sorted in the order that you want by specifying the order under Options.