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.
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.
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!
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