Skip to main content
Question

Can duplicate entries be highlighted in a report?

  • December 12, 2013
  • 0 replies
  • 49 views
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
This topic has been closed for replies.

  • JimLieder
  • Author
  • Registered
  • December 16, 2013
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>";,
   [Equipment 1]>" ",If([Equipment 1]=[Equipment 3],"<div><img src=\"https://images.quickbase.com/si/16/241-triang_yellow.png\"</div>";,
   [Equipment 1]>" ",If([Equipment 1]=[Equipment 4],"</div><img src=\"https://images.quickbase.com/si/16/241-triang_yellow.png</div>";,
   [Equipment 1]>" ",If([Equipment 1]=[Equipment 5],"<div><img src=\"https://images.quickbase.com/si/16/241-triang_yellow.png</div>";,

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

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

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

null)))))))))))
  • anomDiebolt
  • Registered
  • December 18, 2013
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.
  • RahulRahul
  • Registered
  • May 2, 2017
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 
Terms & ConditionsAccessibility statement