Forum Discussion

Qrew Trainee

5 years ago

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 ...

Formulas and functions

reports and charts

MarkShnier__You
5 years 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
------------------------------

MarkShnier__You

Icon for Qrew Legend rank

Qrew Legend

5 years 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
------------------------------

RebeccaMoore
Qrew Member
5 years ago
How would you use "null" in this formula? I'm getting a syntax error.

------------------------------
Rebecca Moore
------------------------------
- MarkShnier__You
  Qrew Legend
  5 years 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
  ------------------------------
  - RebeccaMoore
    Qrew Member
    5 years 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
    ------------------------------
EmberKrumwied1
Qrew Trainee
5 years ago
Thanks Mark! That was the ticket!

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