- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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:
- Project 1:
- Task 1
- Task 2
- Project 2:
- Task 1
- Task 2
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.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 09, 2024 09:25 AM
Happy to help 🙂