Can I produce a list of only unique contractors we have used on certain jobs?

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

I would like a unique list of contractors we have used on certain jobs.  I don't want the list to be populated with several of the same contractors.  In other words, we have used ABC company on 50 XYZ-owned jobs, but I only need ABC listed once.  Is there a way to produce a lookup with unique names only?  ie  ABC on XYZ, JKL on XYZ, DEF on XYZ, ABC on 123, ABC on 678, etc.


Photo of Brad

Brad

  • 0 Points

Posted 3 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 65,542 Points 50k badge 2x thumb
no problem,

Make a Report of type Summary (not a table Report, a Summary report)  and group by Contractor.