Any ideas on how to remove duplicates based on duplication in a specific field in an RG?

Greetings, all. I have a list of things in an RG that record entries when people purchased a specific product. While each thing is unique, the product purchased may repeat for a certain customer. I need to create a list of things that show the most entry for each product to remove older duplicates.

As you can see, Item #1 is showing twice because a customer purchased access multiple times. Here is a sample of the data behind the scenes:

In this example, I’d want to group all Item #1 and Item #2 entries together and simply show the top entry (most recent).

Any ideas? I thought:grouping, but that obviously complicates actions like filters.

You should be able to use the :unique items operator for this. Feel free to reach out to us at [email protected] for additional details!

@eve, thanks so much for replying. Unfortunately, I wasn’t able to use the :unique items operator on the purchase history dataset as it kept returning the unique purchases (which was all of them) but didn’t support designating specific fields for duplicate evaluation such as show unique things ONLY based on repeat values in the Item column.

Other tools I’ve used support this kind of “selective de-duping” (feature request in the works? :grinning:). Bubble’s Group By is the closest equivalent, but sadly, it then left the data aggregated and inaccessible because it changed the rg’s data type. :frowning_face:

I finally figured out a workaround by:

  1. Creating hidden repeating groups that contained the filtered results for each filter category (e.g., Active, Expiring, Expired).
  2. Setting the main rg to conditionally toggle between which hidden rg it referenced when a user makes a filter selection, thus ensuring it didn’t re-run a search.
  3. Setting the rg’s data source to the products linked to the purchase history and only THEN applying the :unique items operator.

Not the simplest solution, but it works.

Expiring filter state:

Expired filter state with no duplicates:

This topic was automatically closed after 70 days. New replies are no longer allowed.