Hello,
I have a task management use-case that requires a Ragged Hierarchy like the example below, where teams can belong to a department or also directly to the company, skipping a hierarchy level (in the real use case there are 5 levels).
Company
├── Department A
│ └── Team 1
│ └── Team 2
└── Department B
│ └── Team 3
└──── Team 4
Users can be requesters or supporters and can be assigned to any level of this hierarchy.
I modelled the ‘Hierarchy item’ table simply as a name and a parent field, because of the need of supporting a ragged hierarchy.
The task assignment works hierarchically. For example: If a supporter is assigned to Department A, he/she will only receive requests from Team 1 or 2.
So in order to know who can take over a task I have to check if the hierarchy item of the requester is a child of the hierarchy item of the supporter.
You can break this out in 2 topics:
-
Build the relation between parent-children in the ‘hierarchy item’ table: This is quite trivial to do in Coda or Glide with a filter formula, but have not managed to make it work in Noloco. I thought this could be solved with ‘Automatically link these records’ within the Parent field, but have not been able to make it work.
-
Get all children for a specific hierarchy item: Again trivial to achieve in Coda and harder but doable in Glide using a Javascript formula. Noloco formulas are more limited, so is the only option to use a workflow?
Thanks for your help!
Pablo