Forum Discussion

VivekVishwanat3's avatar
VivekVishwanat3
Qrew Cadet
7 years ago

Customize filter tab

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.


reports and charts
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    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's avatar
    KevinSlider
    Qrew Trainee
    7 years ago
    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?
  • VivekVishwanat3's avatar
    VivekVishwanat3
    Qrew Cadet
    7 years ago
    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?

    • KevinSlider's avatar
      KevinSlider
      Qrew Trainee
      7 years ago
      If you change the field to a numeric type field, this will work. right now it is a text field. 
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    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.