Sorting of Records in A Summary Report

  • 0
  • 1
  • Question
  • Updated 9 months ago
  • Answered
Is there an alternative way to sort records in a summary report rather than resorting to additional formula field.  As an example my depts are currently alpha sorted and I need a certain order.  
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,132 Points 3k badge 2x thumb

Posted 9 months ago

  • 0
  • 1
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,132 Points 3k badge 2x thumb
Need some help here. 
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,756 Points 5k badge 2x thumb
> and I need a certain order.

What type of certain order do you want?

Thanks,
Gaurav
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,132 Points 3k badge 2x thumb
It is sorting in alpha order at the moment, I would like to have an order predefined which can best achieved by adding a prefix number but I am preferring not to have unsightly numbers in values. 
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,296 Points 50k badge 2x thumb
I that the only way to control the sort without cheating uf if the sort Fields happen to be from multiple choice fields where the choices are contained in the field properties.

Aside from that the typical cheats are having a formula field to number the choices or else, and I often do this, is to have a cheat formula field which prefaces the words with an appropriate number of leading spaces to get the sort order correct.
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,132 Points 3k badge 2x thumb
Thanks a lot Mark.  The first option could work but the choices are linked to a table (banners) created by you. 

So I am really left with the good old option of creating a formula field. And the another formula field to remove the numbering. 
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,296 Points 50k badge 2x thumb
so why not load the Banner table with the sorted names in addition to the clean name.

ie if you wanted Woolworths to sort first, you would load this new field in that table as " Woolworths" ( you would not actually load the quotes, but I'm showing that you would load with a leading space as spaces sort first). The field would be called [Banner(Sorted])

Then just look that up to any table where you need a sorted banner for summary reports.
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,132 Points 3k badge 2x thumb
Thanks.  This is all good.  appreciate your help.