Flip recursive group by in table

[tycecycle]

I don’t love the title for this post, but hopefully an explanation will clarify. I have a database named “Company” with a relation field called “Contractor” that self-references the Company database. I create a new table view for the Company database. I’d like to have each “Company” as the top level grouping, and see all the related contractors grouped under each company.

However, the only grouping I’m able to produce is “Contractor” as the top-level grouping.

Am I thinking about this problem wrong, or is something like this just not possible in Fibery right now?

I’ve annotated some screenshots to show what I’m trying to accomplish as well.

[Chr1sG]

When you open the dropdown to choose the database to Group by, you should see both ends of the many-to-many relation.
What is the name of the corresponding field that is the other direction to Contractor?

[tycecycle]

It’s vendor, and that was totally the issue . Thanks!

[tycecycle]

Actually, that’s still not quite behaving as expected. It doesn’t seem to be grouping by Vendor, which would be the same as the Name Field.

[Chr1sG]

What filter do you have applied?

[tycecycle]

A filter that hid the grouping by vendor behavior.

It points to the fact I need to think differently about how to create this view, but everything is working as expected.