Skip to main content

I want to order my Custom Object Records of dance classes in a course in ascending order. Each class in the course is numbered, 1 through 12.

 

When I select to sort the List View, it puts classes number 10, 11 and 12 before class number 2. (see attached screenshot)

 

List View Sort Order for numbers

 

This help article suggests to change the Field Type to Numbers for correct sorting. I could change it to only the number of the class, as other information (course and dance school) is found in other Fields. However, this is important contextual information I would like to always have at hand when referencing each of these classes in e.g. Reports. 

 

I would therefore humbly ask if you awesome Trailblazers out there have another idea for a workaround this. 

 

I much appreciate your time in reading this question, and thank you in advance for any ideas you may have 

 

#List Views

2 answers
  1. Zack Terry (Fast Slow Motion) Forum Ambassador
    Apr 12, 2024, 12:10 AM

    Hi @Sebastian Sonesten,

     

    Add a leading 0 to each of the single digits class names - ‘01 UDC Rudea de Casinno VT 23’, ‘02 UDC Rudea de Casinno VT 23’, etc.

     

    Example: Hi , Add a leading 0 to each of the single digits class names - ‘01 UDC Rudea de Casinno VT 23’, ‘02 UDC Rudea de Casinno VT 23’, etc.

0/9000