Skip to main content
Question

Can you sort records on the calendar report?

  • November 25, 2017
  • 0 replies
  • 117 views
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?
    This topic has been closed for replies.

    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.
    • TomZ
    • Quickbase Alumni
    • February 8, 2018

    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.

    Terms & ConditionsAccessibility statement