Can you sort records on the calendar report?

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
Can you sort records on the calendar report within the monthly view that shows each day? If not, Can you change the default order on a drilldown report when you click a date?
Photo of Marc Nelson

Marc Nelson

  • 322 Points 250 badge 2x thumb

Posted 1 year ago

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

QuickBaseCoach App Dev./Training, Champion

  • 65,542 Points 50k badge 2x thumb
They sort according to how the default report is set for the detail record.

The default reports allows you to set a single field to sort on, but you can always create compound formula text field to list some fields together with hyphens as a separator of you want to have multiple fields in your sort sequence formula.

The default report is accessed by getting into Setungs for the table and then into reports and then look to the top right.
Photo of Marc Nelson

Marc Nelson

  • 322 Points 250 badge 2x thumb
The compound formula text field is a great tip! That solved my issue. Thanks!!!
Photo of Tom Z

Tom Z

  • 212 Points 100 badge 2x thumb

I have a calendar report in which multiple records in a single date are no longer sorting correctly. I've tried to follow the above advice but it has not worked.  When referring to "the default report" above is this the "default report settings" or the "default calendar settings"?  I've created a compound formula text field that I want to sort on within the calendar (and the default report) but including it in the "Default Sort Order" field in the "Default Report Settings" has not updated the calendar sort order.

(Edited)