Discussions

Expand all | Collapse all

Can duplicate entries be highlighted in a report?

  • 1.  Can duplicate entries be highlighted in a report?

    Posted 12-12-2013 14:55
    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


  • 2.  RE: Can duplicate entries be highlighted in a report?

    Posted 12-16-2013 14:55
    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)))))))))))


  • 3.  RE: Can duplicate entries be highlighted in a report?

    Posted 12-18-2013 12:08
    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.


  • 4.  RE: Can duplicate entries be highlighted in a report?

    Posted 05-02-2017 07:04
    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