Numbered Lists to Assign Employees to Projects
I am working on an internal model where the goal is for employees to input their monthly hourly estimates based on projects they are assigned to. I want employee to be able to go in and input weekly time assumptions based on project.
I have created the following lists: Total Company L1, Clients L2, #Projects L3, #Assignment L4, #Master Employee List...with all "L lists" rolling up into one another.
My vision was to use #Assignment L4 as the "primary input" by publishing it into its own module. Admins would then add the employee and selecting a given name from the #Master Employee List which was added as a property to the L4 list.
My thought was to build a separate module for employees to input time estimates by using #Assignments L4 in the rows and #Master Employee as the page selector. I would then want employees to essentially only have their name be a page selector option and then also only see the projects that they have been assigned to.
Question: Is there a way to make #Assignment L4 only display the projects which the employee is actually assigned to? Is there some other way I should be going about this that will allows this functionality that I have not considered?