Save the date! Join us on October 16 for our Product Ops launch event. Register here.
May 09, 2024 07:29 AM
I have a tasks table with a self-linking field that I use to define task predecessors. Is there a way when adding a predecessor to filter the options to show only those that relate to the relevant project/grouping?
The problem I am trying to solve is that there may be many tasks with the same name so sorting through them to find the correct one takes time. For example, in my task table I may have the following:
When selecting a predecessor for task 2 I have to wade through and find which Task 1 is the correct one for the project.
May be helpful to know: my tasks table has another linked record field that links to a projects table, therefore each task is tied to a project.
Solved! Go to Solution.
May 09, 2024 08:43 AM
This is absolutely possible with the predecessor field! You'd just want to adjust it to a dynamic filter on the predecessor field and pick the linked project field so it will only show tasks that are linked to that project. I've added a screenshot of how I set it up in my own base.
May 09, 2024 08:43 AM
This is absolutely possible with the predecessor field! You'd just want to adjust it to a dynamic filter on the predecessor field and pick the linked project field so it will only show tasks that are linked to that project. I've added a screenshot of how I set it up in my own base.
May 09, 2024 08:48 AM
Ah! So THAT is what that little cog wheel is for on the linked record filter settings. Thanks so much for the help. You're awesome.
May 09, 2024 09:25 AM
Happy to help 🙂