Single task limited relationship custom field
not on the roadmap
Ross McConeghy
It would be extremely useful to be able to add a custom field that can only link to a single task.
This would enable intuitive linking between tasks(records) where there is only a single logical corresponding task(record).
One example is where a certain task is designed to be a single step in a process where that task can only be performed for a single project at a time. Naturally, the "Project" field of the task should be limited to linking only to a single task(record) that represents the entire project within a separate Projects list.
Consider the potential this brings to automation where the referenced task's values could easily be used in automation routines. For example, the automation for a project-related task could assign a newly created task to a project manager(user) that isn't referenced in the immediate task or list and may change depending on the project - that project manager(user) would be stored in a custom field of the task(record) that represents the entire project.
The same concept would apply to numerous use cases that have historically been handled very efficiently using relational databases that enforce one-to-many relationship constraints.
Log In
Luci N.
not on the roadmap
We are closing this feature request as we work to make better use of our feedback boards! Removing old and stale posts will increase the communication between the ClickUp team and our users, as well as allow us to hear more of your great ideas!
If you feel like this request is worth us revisiting, feel free to create a new post for this request!
Ross McConeghy
Another use case for this functionality would be inventory control and purchasing.
One list would contain all the inventory items as individual tasks. A separate list would contain all the vendors the items are purchased from. The inventory list items would have a custom field that references a single vendor in the vendor list.
To trigger the creation of a stock reorder task for an inventory item the stock checker sets the status of the inventory item to "Reorder". The automation creates a new task in a Purchasing list that includes the item's SKU number and description for ordering, it also uses link to the vendor to include the vendor's name and contact information in the newly created task, or it could just link the vendor task(record) directly to a task custom field in the new purchasing task.