Skip to main content
Question

Customize filter tab

  • September 7, 2018
  • 0 replies
  • 123 views
Hi,
I have a field say, Round. having (Round 1 to Round 12 values possible). 

In the filter tab at the left side of the tabular view,"Round" filter is showing as
Round 1
Round 10
Round 11
Round 12
Round 2
Round 3
Round 4
Round 5
Round 6
Round 7
Round 8
Round 9



But Required as
Round 1
Round 2
Round 3
Round 4
Round 5
Round 6
Round 7
Round 8
Round 9
Round 10
Round 11
Round 12



Attached the Screen shot of the scenario




Need help.


    This topic has been closed for replies.

    You would need to contrive so that the Round (space) 1 is actually round (space space) 1 so that the alpha dorf is correct.
    • KevinSlider
    • Registered
    • September 7, 2018
    This is the ugly side of Alpha numeric sorting, If you want to sort by number, you need a numeric field. You could name the field ROUND, and have the choices be numeric 1 - 12. Is the Text value of Round important for the data entry?
    Made the Round as a text Field, with 1-12 as allowable values, and showing the same thing
    1
    10
    11
    12
    2
    3
    4
    5
    6
    7
    8
    9




    what can be done to sort this filter Numerically?

    Ad I suggested above, the sort will be alpha. So either number like

    01
    02
    03

    Or else put a space in front of the single digit values.
    Terms & ConditionsAccessibility statement