Discussions

 View Only
  • 1.  Customize filter tab

    Posted 09-07-2018 09:23
    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.




  • 2.  RE: Customize filter tab

    Posted 09-07-2018 10:04
    You would need to contrive so that the Round (space) 1 is actually round (space space) 1 so that the alpha dorf is correct.


  • 3.  RE: Customize filter tab

    Posted 09-07-2018 13:33
    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?


  • 4.  RE: Customize filter tab

    Posted 09-07-2018 14:34
    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?



  • 5.  RE: Customize filter tab

    Posted 09-07-2018 15:11
    If you change the field to a numeric type field, this will work. right now it is a text field. 


  • 6.  RE: Customize filter tab

    Posted 09-07-2018 14:39
    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.


  • 7.  RE: Customize filter tab

    Posted 09-07-2018 14:39
    It will need to be a Text field type.


  • 8.  RE: Customize filter tab

    Posted 09-07-2018 15:11
    I like the alpha sort using a leading 0, bravo. 


  • 9.  RE: Customize filter tab

    Posted 09-07-2018 16:08
    You can also try using 01,02,03 etc