I want a field that summaries if there are more than one same value in other field.

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • In Progress
I want a field that says 1, 2, 3 or how many times there is the same number in another field. For example, if a field URID has number 90_101 twice. The field should say 2 for both records. Basically a summary field within a table.
Photo of Sania

Sania

  • 476 Points 250 badge 2x thumb

Posted 1 year ago

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

QuickBaseCoach App Dev./Training, Champion

  • 53,842 Points 50k badge 2x thumb
The only way i know to do that natively, is to make a Table of Unique URIDs.  Make the Key field be the URID #

Then make a Summary report grouped by URIDs in the details table and use the More button to copy to another table - and copy these unque URIDs to that table.

Then make a relationship back to the details table and make a summary of the # of details for each URID.  Then look that summary field up down to the details record.

That will work fine, except that you will need to update that table of Unique URID each day or so - or unless you have some other way of ensuring that the URID table has a list of all possible URIDs.