Customize filter tab

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • In Progress
  • (Edited)
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.


Photo of Vivek Vishwanath

Vivek Vishwanath

  • 474 Points 250 badge 2x thumb

Posted 2 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,036 Points 50k badge 2x thumb
You would need to contrive so that the Round (space) 1 is actually round (space space) 1 so that the alpha dorf is correct.
Photo of Slider

Slider

  • 1,326 Points 1k badge 2x thumb
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?
Photo of Vivek Vishwanath

Vivek Vishwanath

  • 474 Points 250 badge 2x thumb
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?

(Edited)
Photo of Slider

Slider

  • 1,326 Points 1k badge 2x thumb
If you change the field to a numeric type field, this will work. right now it is a text field. 
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,036 Points 50k badge 2x thumb
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.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,036 Points 50k badge 2x thumb
It will need to be a Text field type.
Photo of Slider

Slider

  • 1,326 Points 1k badge 2x thumb
I like the alpha sort using a leading 0, bravo. 
Photo of Ron Ruetz

Ron Ruetz

  • 170 Points 100 badge 2x thumb
You can also try using 01,02,03 etc