Forum Discussion

EmberKrumwied1's avatar
EmberKrumwied1
Qrew Trainee
5 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
    mark.shnier@gmail.com
    ------------------------------

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
    mark.shnier@gmail.com
    ------------------------------
    • RebeccaMoore's avatar
      RebeccaMoore
      Qrew Member
      How would you use "null" in this formula?  I'm getting a syntax error.

      ------------------------------
      Rebecca Moore
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        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
        ------------------------------
    • EmberKrumwied1's avatar
      EmberKrumwied1
      Qrew Trainee
      Thanks Mark!  That was the ticket!

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