Discussions

Expand all | Collapse all

Table Group By Heading

Jump to Best Answer
  • 1.  Table Group By Heading

    Posted 22 days ago
    Is it possible to change the heading that is displayed when Grouping records?

    I have a table of Transactions that contains a checkbox field.  My default report is set to Group By the checkbox.  So all checked items are together and all unchecked items are together.  Works great, but the Heading for each section is the value of the checkbox.  Thus the unchecked items heading is "no" and the checked items heading is "yes".

    Is there anyway to change the "no" and "yes" to something with a bit more meaning?

    Thanks

    ------------------------------
    Ember Krumwied
    ------------------------------


  • 2.  RE: Table Group By Heading
    Best Answer

    Posted 22 days ago
    np, just make a formula text field to calculate to mote appropriate words and group by that field.

    IF([Approved]=true, "Approved", "Denied")

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Table Group By Heading

    Posted 22 days ago
    How would you use "null" in this formula?  I'm getting a syntax error.

    ------------------------------
    Rebecca Moore
    ------------------------------



  • 4.  RE: Table Group By Heading

    Posted 22 days ago
    You would have to show me your formula and say what logic you are trying to accomplish.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 5.  RE: Table Group By Heading

    Posted 22 days ago
    If([Contact Type]="Buyer","Buyer","null"

    Contact Type is a multiple choice field. I'm trying put "Buyer" into a field if the "Buyer checkbox is ticked. I will probably be changing the actual text later as I'm trying to work out the formula.

    Thank you for being so patient with me. I must be driving you crazy. I have to have the bulk of this set up by Monday.

    ------------------------------
    Rebecca Moore
    ------------------------------



  • 6.  RE: Table Group By Heading

    Posted 22 days ago
    If([Contact Type]="Buyer","Buyer")

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 7.  RE: Table Group By Heading

    Posted 22 days ago
    Thanks Mark!  That was the ticket!

    ------------------------------
    Ember Krumwied
    ------------------------------