How to Display Duplicate Entries in a Table

armand1 · 2025-02-26T08:42:56.877Z

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 · 2025-02-26T08:56:01.384Z

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 · 2025-02-26T08:59:58.266Z

Thanks you i try this one

armand1 · 2025-02-26T09:03:13.383Z

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

adamhholmes · 2025-02-26T09:28:43.281Z

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 · 2025-02-26T09:33:31.812Z

Screenshot 2025-02-26 173236807×440 19 KB

Screenshot 2025-02-26 173241834×362 19.3 KB

Screenshot 2025-02-26 173246953×397 19.3 KB

armand1 · 2025-02-26T09:34:00.957Z

here are the screen shots

image1713×562 15.7 KB