Right now I can only add relations of “*-to-many” type (collections) to a smart folder. I would also like to be able to add relations of *-to-1 type. Use case: in my Project DB I have a 1-to-1 relation to a Meeting Notes entity. I would like to see the Meeting Notes entity listed in the Project’s smart folder, where it would serve as a shortcut. That way I can open it directly from the sidebar without having to first open the Project and find the Meeting Notes relation.

Related: [image] Use Many-to-One Relationships in List View Ideas & Features See comment in the Many-to-Many feature request. Use Case: Single Employee Filling Multiple Roles in Org Hierarchy The list hierarchy is an ideal candidate to show an organization tree. The idea was to show the roles (Seats), then assign people to one or more Seats. A “Seat” can have one or more child seats below it that the list view can display. I then had an “Employee” model that can be associated with one or more seats. So, I expected to be able to show the same employee showing up multip…

This is very similar to my productivity use case, combining tasks, projects, notes, meetings I also find the restrictions of relation types a challenge and would love to be able to have the same entity type appear ore than once, e.g. a notes as children of tasks, and of projects

Allow adding *-to-1 entities to Smart Folders

Ideas & Features

Chr1sG May 27, 2022, 4:10pm 2

Topic		Replies	Views
Re-use existing relation views in smart folders Ideas & Features	2	63	June 12, 2026
CHANGELOG: March 23 / Many-to-many relations in Lists and Smart Folders, Open Entities in panel from Board & Table View Changelog	1	963	March 24, 2022
Add Documents and Views to Root of Smart Folder Misc	12	2053	May 24, 2023
Grid view doesn't show any related entities in Smart Folder Bugs & Issues table-view	13	503	October 9, 2023
Organise smart folders Ideas & Features	3	343	February 21, 2024

Allow adding *-to-1 entities to Smart Folders

Related topics