How can I group this data by department? Any idea?

[agungmrf]

I plan to group departments, how do I do that? but i don’t have the solution to solve this problem. anyone can help me to solve this problem?

[Darren_Murphy]

Add a Collection component to your screen, then under the component options you will find a setting for grouping the data.

[agungmrf]

@Darren_Murphy

Add a Collection component to your screen, then under the component options you will find a setting for grouping the data.

Thanks, but I want it to appear that the product folder is not duplicated. So every time an item is added to the product department/ product folder, the product folder is not created again? do you know it?

[agungmrf]

So the product folder is still 1

[Darren_Murphy]

I don’t really understand. I don’t see any Product related table or column in your screen shots.

Reading between the lines, you most likely need to create a relation and use that as the source of your collection, but based on what I see it’s very difficult to say exactly how that should be configured.