How do I search and group all matching and repeating fields?

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

How can I create a table or summary that shows all records where say there are multiple instances of Field A AND Field B, then sort them. 

For example:  I kept a record of each person (Field A) taking an item (Field B), I'd like to know every time each person takes comes back for the same item and then sort them by any given item or person.

Photo of Brian

Brian

  • 0 Points

Posted 3 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 62,448 Points 50k badge 2x thumb
Do we suspect that someone been raiding the Stationary Room paper clip supplies?  no problem.

It is really the same answer as this one, 

https://quickbase-community.intuit.com/questions/1369779-can-i-sort-by-a-given-field-and-the-number-...


But you would first group by Person Name and then Group by Item.  Then again double click to get to descending sort and save.  The paper clip villains will float to the top.




... but you cannot filter on just multiples, just sort by the multiples at the top.