Skip to main content
Question

FY in numerical order on Chart and Dropdown lists

  • January 30, 2024
  • 0 replies
  • 50 views
Forum|alt.badge.img+4

I have a general reference table for Fiscal Year.  (For consistency purposes.)  The problem is, the end result is twofold...

  • On a drop down, the oldest years appear first, resulting in a required scroll down to get to the most current year (Would like to reverse this.  Newest and future years at the top of the drop down.)
  • In a chart, the chronological order ends up being "reversed".  I would like it go left to right, instead of right to left.  See attachment.


------------------------------
Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)
IT Director City of New Braunfels
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+22
    • MarkShnierYou
    • Quickbase Alumni
    • January 30, 2024

    It sounds like you're saying you have a standard table from which the fiscal year gets selected in the drop-down fields. You are fully in control of the sort of that drop-down field either by the default sort for the whole table which is set in Settings then reports and then at the top right under table report defaults, or else you can make a custom report where you control the sort and set the form to use that report for the drop-down list.

    For charts, you should be able to control the sort on the X axis by using the sorting section of the chart settings.



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement