Grouping by referenced virtual column (list)

Hi there!

 

I have used this logic by @MultiTech to create an app that holds many-to-many relationships. I have a question about grouping.

 

In my app, a capability (“order”) can be supported by many applications (“products”). Vice versa, an application (“product”) can support multiple capabilities (“orders”).

 

In my Application View where all applications are listed, I want to be able to group by (related) Capability. 

 

I want my Applications View to show something like this:

 

Capability A:

Application 1

Application 2

 

Capability B:

Application 2

Application 4

 

Capability C:

Application 3

 

As you can see, one application can be grouped under multiple capabilities (example application 2).

 

However, the app shows the count of related capabilities (a number between brackets is the number of capabilities the application supports):

 

Related Capability (2):

Application 1

 

Related Capability (3):

Application 2

 

How do I make it work?

 

All the best,

Kay

0 16 832
16 REPLIES 16
Top Labels in this Space