Forum Discussion

EmberKrumwied1's avatar
EmberKrumwied1
Qrew Trainee
6 years ago
Solved

Table Group By Heading

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
------------------------------
  • 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
    [email protected]
    ------------------------------

6 Replies

  • 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
    [email protected]
    ------------------------------
    • RebeccaMoore's avatar
      RebeccaMoore
      Qrew Member
      How would you use "null" in this formula?  I'm getting a syntax error.

      ------------------------------
      Rebecca Moore
      ------------------------------
    • EmberKrumwied1's avatar
      EmberKrumwied1
      Qrew Trainee
      Thanks Mark!  That was the ticket!

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