Remove Duplicate within Repeating Group

I am planning to use repeating group inside repeating group, however the parent repeating group shows each item, which consist duplicate values.

I have tried to used expression Search for topics:each item's category:unique elements on the parent repeating group and it works, however its type of content needs to become text. This creates another problems, which I couldn’t acccess another field on the parent’s group.

Looks like your outer RG needs to be a search on categories and the nested RG needs to be a search for topics where category = parent category.

Yeah that works, however as I mentioned earlier, I can’t access another field from the parent’s group.

There’s another parameter besides Category and Topic, let’s call it “Group”. I need both Category and Topic to be tied to the parent group.

If I set the outer RG to Categories where Group = Parent Group, and the nested RG to Topics where Category = Parent Category, the direct relationship between Topics and Group is lost. Keep in mind, currently the RG data source type of contents are text and not table.

Create a new field called Category_text that contains the text version of the category and apply unique items on that

hi yall, so after wondering for a while I solved my issue. Instead of using unique elements, I am using grouped by, which could be used for several variable, in my case grouped by category and Group, which was works!

1 Like

The cleanest way to solve this is to separate your database into Categories and Topics.

  • Category has a Name and a List of Topics.

  • Topic has a Title and a linked Category.

Then in your UI:

  • Parent repeating group → Search for Categories (so each Category shows only once).

  • Inside that → Nested repeating group → Current cell's Category's Topics.

This way, you don’t need :unique elements at all, and you get a nice hierarchy:
Category A → Topic 1, Topic 2, Topic 3
Category B → Topic 1
Category C → Topic 1, Topic 2

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