Creating a list based on another field
I have been trying to achieve this for years and we?ve done a few things to work around the issue. I have a team of people I want to dedicate to a project. I then want only that list of people to be s...
Forum Discussion
Do you mean if Project Manager is always listed as project manager on specific tasks?
If so, no, they aren�t consistent.
Project Managers can sometimes play the role of Writer and Writer can also play the role of Project Manager.
If so, no, they aren�t consistent.
Project Managers can sometimes play the role of Writer and Writer can also play the role of Project Manager.
- That's unfortunate (from a program perspective).
I think you're best bet is to handle this via a "Project Assignments" table and then connect the tasks to the assignments. Thus creating your conditional user dropdown you need.
I know you found that clunky, but if you set it up the right way, it can be vary clean and easy to use.
**Native user list fields cannot be filtered dynamically. Thanks Matthew.
Yea, we didn't like this entry method due to the fact that you could add "Resources" in the Project Assignment as many times as you wanted. The data at the end of the day wasn't accurate. When you look to see how many projects X worked on for the month, that number would be completely off because she may have been entered in multiple times. Not to mention the additional headache of having to clean up child records when parent records were deleted.
