Grade Sort value in Advanced Lists

Any Advanced List that uses the Grade Level object is limited in its ability to sort by Grade. Sorting by the Grade Level Description applies an alpha sort which puts the numeric grades first alphabetically followed by the non-numeric grades. You get 1, 10, 11, 12, 2, 3, 4, 5, 6, 7, 8, 9, K, PK. Using the Grade Level Abbreviation gives 01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12, K, PK.

I tried to use the Grade ID field, but 1 of our grades was created out of order, so it ends up sorting out of order at the end of the list.

What we need is to be able to leverage the existing Display Order field from the Edit Grade Level screen or to have a Grade Sort value on the Grade Level object.

  • john simpson
  • Aug 11 2021
  • Attach files