Quick Base Discussions

Expand all | Collapse all

Calendar month text field sorting

  • 1.  Calendar month text field sorting

    Posted 09-02-2017 16:42
    I'm working with a text multiple choice field that is used to choose a month of the calendar year. The months are listed as the options in the dropdown and I've chosen for them to 'Sort in this order', so they will sort January-December. This works fine while using the field to sort reports. But when used a Dynamic Filter this field defaults to sort alphabetically. Is there a way to force it to sort January-December?

    Thanks!


  • 2.  RE: Calendar month text field sorting

    Posted 09-02-2017 17:01
    A worka round is to create a new formula text fields use as a Dynamic Filter which will result in values like

    1-Jan
    2-Feb
    Etc
    12-Dec

    You would need to have a leading space in front of the months from1-9