Can duplicate entries be highlighted in a report?

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
Is it possible to use row colorization to highlight duplicate entries in a report using a calculated value? I have a jobs table and and each job can have assigned operators and equipment. The equipment has a unique identifier that can be used to determine whether a duplicate entry is present, but I can't figure out the formula.

The attachment shows a example of the assigned equipment for a job. The same piece of equipment has been assigned 3 times, and I want to highlight the duplicate rows.

Thanks,

Jim
Photo of Jim Lieder

Jim Lieder

  • 0 Points

Posted 6 years ago

  • 0
  • 1
Photo of Jim Lieder

Jim Lieder

  • 0 Points
Here's the formula I added to indicate that there are duplicate equipment assignments for a job.  This will notify the users of duplicates equipment assignments for the same job record but not across all job records.

If([Equipment 1]>" ",If([Equipment 1]=[Equipment 2],"<div><img src=\"https://images.quickbase.com/si/16/241-triang_yellow.png\"</div>&quot;,
   [Equipment 1]>" ",If([Equipment 1]=[Equipment 3],"<div><img src=\"https://images.quickbase.com/si/16/241-triang_yellow.png\"</div>&quot;,
   [Equipment 1]>" ",If([Equipment 1]=[Equipment 4],"</div><img src=\"https://images.quickbase.com/si/16/241-triang_yellow.png</div>&quot;,
   [Equipment 1]>" ",If([Equipment 1]=[Equipment 5],"<div><img src=\"https://images.quickbase.com/si/16/241-triang_yellow.png</div>&quot;,

   [Equipment 2]>" ",If([Equipment 2]=[Equipment 3],"<div><img src=\"https://images.quickbase.com/si/16/241-triang_yellow.png</div>&quot;,  
   [Equipment 2]>" ",If([Equipment 2]=[Equipment 4],"<div><img src=\"https://images.quickbase.com/si/16/241-triang_yellow.png</div>&quot;,
   [Equipment 2]>" ",If([Equipment 2]=[Equipment 5],"<div><img src=\"https://images.quickbase.com/si/16/241-triang_yellow.png</div>&quot;,  

   [Equipment 3]>" ",If([Equipment 3]=[Equipment 4],"<div><img src=\"https://images.quickbase.com/si/16/241-triang_yellow.png</div>&quot;,
   [Equipment 3]>" ",If([Equipment 3]=[Equipment 5],"<div><img src=\"https://images.quickbase.com/si/16/241-triang_yellow.png</div>&quot;,

   [Equipment 4]>" ",If([Equipment 4]=[Equipment 5],"<div><img src=\"https://images.quickbase.com/si/16/241-triang_yellow.png</div>&quot;,  

null)))))))))))
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,434 Points 20k badge 2x thumb
Within any report you could have several sets of duplicate records so you would want to colorize each set in a different color and sort/group the records so that duplicate records abut each other. You could write a short script to do this that would use underscore and jQuery to identify the duplicate rows and to highlight them accordingly. But the details would depend you your specific table, query and fields so I can't provide a generic solution.
Photo of Rahul

Rahul

  • 76 Points 75 badge 2x thumb
Hi Dan, Hope you are doing good !  Need you urgent Guidance and help  :)

Could you please guide what steps needs to follow if i want to write a script to find duplicate records in a table after bulk import iof data ? as i don't see any option in native QB :(

I have already posted a separate question and mentioned detail here -
https://community.quickbase.com/quickbase/topics/send-email-notification-when-user-importing-the-dat...

I hope, am clear about the problem but still if you have any query then pls let me know.

Thanks in advance for your help :)

Regards,
Rahul