How can I create a report that groups by the values in multiple fields?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

(This is a simplification buts gets at the issue):  A table of Jobs.  Lead Person field.  Assistant Person field.  A person could be either.  I want a report grouping all jobs assigned to each person. (Assistant is usually blank)


Photo of BarryJake

BarryJake

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 59,768 Points 50k badge 2x thumb
Can you tell me the field type for the Assigned Person?
Photo of BarryJake

BarryJake

  • 0 Points
User (is that better or worse than text - my guess is 'better')
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 59,768 Points 50k badge 2x thumb
I would try a formula field like

ToUserList([Lead person],[Assistant Person])

 and then try grouping the report on that field.

But a record will only appear once on the report.
Photo of BarryJake

BarryJake

  • 0 Points
Thanks Mark.  I had a feeling that there might not be a way to do it.  I was a Lotus Notes developer for many years - I miss its multi-valued fields in this context!