Forum Discussion

BobThomas1's avatar
BobThomas1
Qrew Cadet
4 years ago

Contract start date is not completely sorted by latest date.

I am working on improving my company's Quickbase Contracts App. So in looking at the latest Contracts, sorting by latest 'Start Date' I am showing data sorted into monthly periods, which are sorting p...
reports and charts
BobThomas1's avatar
BobThomas1
Qrew Cadet
4 years ago
Sean, this is what I get when I check the field properties of the 'Start Date' field. Maybe because the data is in groups by month/year. I don't see an option to add another sort?

------------------------------
Bob T.
------------------------------
SeanConnaughto1's avatar
SeanConnaughto1
Qrew Cadet
4 years ago
Hi Bob,

To get the sorting options, you will need to do a few steps:

1. Navigate to the report you wish to adjust
2. Click on "Customize this report" (Top right of screen)
3. Scroll down to "Sorting and Grouping" (Near the bottom)

4. Once you make the changes, click save in the top right of your screen


I hope that helps!

------------------------------
Sean Connaughton
------------------------------
  • BobThomas1's avatar
    BobThomas1
    Qrew Cadet
    4 years ago
    Sean,

    I don't get the option on the data table page. But I did go the reports and found one, not sure who set these up. But I see they used one sort and it did put the data into Chronological order descending after I sorted that way. I also tried the ascending and it shows then earliest to later. I can make changes permanent if I want.

    On the page itself, you don't have the option, but the sorting is not all chronological.

    Since I see a lot of reports on this page I can make this work on a dashboard page and opens some options making this more user friendly, which is the goal for me in 2022. 

    Thank you for your help.

    ------------------------------
    Bob T.
    ------------------------------