Forum Discussion
_anomDiebolt_
8 years agoQrew Elite
I created a quick demo of one way to do this with script.
Have a look at the number of Jobs each Worker currently has:
List All Workers and Number of Jobs
https://haversineconsulting.quickbase.com/db/bmnpvxnfk?a=td
Then open the page to create a new Job:
New Job
https://haversineconsulting.quickbase.com/db/bmnpvxngn?a=nwr
You will notice that the first Worker with the least number of Jobs is pre-selected as the related Worker for the about to be created new Job.
I did not bother excluding Workers with more than 150 Jobs from potentially being assigned a new Job but this and any other business logic can easily be added.
Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=565
If you need further assistance implementing this solution feel free to contact me off world using the information in my profile:
https://getsatisfaction.com/people/dandiebolt
Have a look at the number of Jobs each Worker currently has:
List All Workers and Number of Jobs
https://haversineconsulting.quickbase.com/db/bmnpvxnfk?a=td
Then open the page to create a new Job:
New Job
https://haversineconsulting.quickbase.com/db/bmnpvxngn?a=nwr
You will notice that the first Worker with the least number of Jobs is pre-selected as the related Worker for the about to be created new Job.
I did not bother excluding Workers with more than 150 Jobs from potentially being assigned a new Job but this and any other business logic can easily be added.
Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=565
If you need further assistance implementing this solution feel free to contact me off world using the information in my profile:
https://getsatisfaction.com/people/dandiebolt