How to Display Duplicate Entries in a Table

[armand1]

Hey Bubble community!

I’m working on a project where I need to identify and display duplicate records from my database directly in a table element. I want the table to highlight or list items that appear more than once based on a specific field (like email, product name, etc.).

I’m curious:

• What’s the best way to filter and show duplicates in Bubble?
• Can we make it dynamic so the table updates as new data comes in?
• Bonus: Any ideas on visually marking these duplicates — maybe with a red icon or bold text?

Would love to hear your strategies, workflows, or plugins you’ve used! Let’s crack this together.

Looking forward to your insights!

[adamhholmes]

To find duplicates based on ‘product name’ you can do a search, and then group by product name (with an aggregation of count).

To display only the product names with more than one entry, you can filter the groupings by count where the count is more than 0.

To display the actual products you can use each grouping’s Product.

You can merge that with a regular search for products if you want to display all Products.

You can use a condition such as (this product is in the groups search’s each item’s product) to visually identify duplicate products.

[armand1]

Thanks you i try this one

[armand1]

the problem is the product is a text so it will show exact only

[adamhholmes]

I don’t understand what you mean? (you said you want to do it based on a specific field, so how is it a text)?

Maybe share some screenshots of your database set up, and clarify exactly what you’re trying to do here.

[armand1]

[armand1]

here are the screen shots