[DONE] Many-to-many relationships should be usable for levels in lists

Ideas & Features
22

Implemented in the latest release CHANGELOG: March 23 / Many-to-many relations in Lists and Smart Folders, Open Entities in panel from Board & Table View

1 Like
23

@ihartrafimovich am I correct in assuming that the current release only addresses the first item? Is there a plan for the other limitations on the list in the near future?

1 Like
24

@ihartrafimovich, I went back to an app I was building that ran into issues with this view. The improvements help somewhat, but I ran into an issue trying to visualize something I thought would be supported.

I have a hierarchy of “Seats”, which represents our roles in our organization. This is a methodology leveraged by EOS, which has you define the roles as Seats you have to fill with someone. So, the idea is you could have a single individual filling multiple seats for some time before you hire on more people to divide the Seats up. For example, maybe an employee “Susan” is both our Product Designer under the Product Lead and is the Graphic Designer under Marketing Lead.

image
image1590×1518 128 KB

image
image3642×1366 393 KB

In this image, you can see Susan assigned as the Employee in the Visionary seat (role). However, you can’t select the Employee from the Levels configuration.

I can show the one-to-many relationships from Seat, but not the many-to-one relationship to Employees. I assume that the many-to-many work should enable this visualization as well, right? Or, is that what you are referring to below:

2 Likes
25

Hi!

Honestly, I never thought about List from this perspective.

It looked like a useless case for me, and I would prefer not to pollute the List setup with options that nobody won’t use. But you have opened my eyes now :upside_down_face:.

It seems that is not so hard to implement, but I don’t know when I will have a timeframe to come back to the feature.

For now, I can offer two workarounds, which you yourself have probably already guessed:

  1. You can select the Employer field to display on Seat cards, and easily open it in a panel by clicking with a pressed Alt key. Besides that, such pieces of data one day will become editable, so will be a quick option to choose the Employer.

  2. You can convert the relation to many-to-many and manage data consistency manually. Or maybe it can be done with Automations, I’m not sure.

26

Thanks, just wanted to check before creating a separate request. I just created this: Use Many-to-One Relationships in List View