Grouping based on relations

Enable grouping in a gallery or table view based on related items.

Example: I want to create an asset gallery of images and I want to organise them into groups. For that I have a second database called ‘asset groups’. The asset is linked in a one-to-many (edit: many-to-many) relationship to the group, i.e. one asset can be in many groups. Now in my gallery view I would like to group my assets based on this, but it’s not possible. I can create a multiselect field in the asset which does the job correctly, but in order to allow customers to easily create new groups that is not a feasible option.

I assume that you actually mean a many-to-many relation, since one-to-many would imply that only one asset could be in any group

Thanks @Chr1sG, you are right, brain fart from me, requires a many-to-many relationsship. Does not change this problem though.

It should be possible to group using a many-to-many relation field. Perhaps you can share a video or screenshot showing the problem you’re having.