Discussions

 View Only
  • 1.  Table Group By Heading

    Posted 05-08-2020 17:09
    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 05-08-2020 17:17
    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 05-08-2020 17:26
    How would you use "null" in this formula?  I'm getting a syntax error.

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



  • 4.  RE: Table Group By Heading

    Posted 05-08-2020 17:49
    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 05-08-2020 18:55
    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 05-08-2020 18:57
    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 05-08-2020 17:29
    Thanks Mark!  That was the ticket!

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