We are looking for a workflow to allocate staff to certain jobs based on their weekly availability. The data that we have are as below
1- list of job request by week and by staff grade
2- list of available resources by week including staff name and grades
what function or workflow can we use to assign staff to a job based on their weekly availability and their job requirement (i.e. grade).
Our challenge is if a staff is assigned to a job on a certain week how do we prevent the same staff from being allocated to another job within the same week?
Hi @PAbarr
This should be achievable. Would you be able to provide sample input data and expected outputs?
User | Count |
---|---|
19 | |
14 | |
13 | |
9 | |
8 |