Auto assign Member to tasks

[Sunny]

I am currently working on a database at work that required us to assigned
tasks to members of my office. Currently, we are maunally assigning tasks to
everyone.

Is there a way to have tasks automatically assigned to each member rotating
in-turn procedure?

Thanks in advance

 

[strive4peace]

Hi Sunny,

yes, it is possible

what is the structure of your data? What kind of tasks are these? will
each person get just one task? How often do you re-assign them?

How many tasks are there? How many people get a task?


Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
have an awesome day
*

 

[Sunny]

Crystal,

Thank you for the quick responses.

what is the structure of your data?

Below is the structure of my data:

Title, Control Number, Date Needed, Status, Assigned To, Assigned By,
Assigned Date.

What kind of tasks are these?

We process IT Requirements and there are constantly requests coming in on a
daily basis. We assigned these tasks to each person in sequence. Each person
that will have to coordinate and complete these requests.

will each person get just one task?

Each person will get multiple task one task at a time rotating in-turn

How often do you re-assign them?

Work task usually will not get re-assign. The person that was assigned will
have to complete the task.

How many tasks are there?

Continueously, tasks will keep coming in.

How many people get a task?

One person per task. That person will have to coordinate and complete it.

 

[strive4peace]

Hi Sunny,

you're welcome

what if a task is not completed yet? Will the person assigned to it
STILL get another task? Or would you prefer to assign a task to someone
who is already done with what they were working on?

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
have an awesome day
*

 

[Sunny]

Crystal,

Thanks for the fast responses.

what is the structure of your data?

The following is the structure of my data:

Title, Control Number, Assigned To, Assigned By, Assigned Date, Status.

What kind of tasks are these?

Our office process IT Requirements that come through.

will each person get just one task?

Each person will be getting multiple tasks, one task at a time.

How often do you re-assign them?

The task don't usually get re-assigned. Not unless the person go on a long
leave.

How many tasks are there?

There are tasks continueously coming in on a daily basis. And they get
assigned to each person in my office to coordinate and completed.

How many people get a task?

We have 5 peoples in the office that get these tasks. Each task will be
assigned to each person in-turn as they come in.

 

[Sunny]

Some tasks will takes a few months or more to get completed, other will only
take a day or two. Yes, the person still gets assigned the next task as they
come in. Anyone of us in the office can have as much as 15 - 20 tasks at one
time.

 

[strive4peace]

Hi Sunny,

it seems like you need to take a little more into account when tasks
are assigned -- you will need more fields to determine things like:

planned task length in days
task 'wight' (numeric) -- this number takes into account length and
difficulty so you can 'balance' the workload better

on your employees, perhaps some are more capable than others -- they,
too, should have some sort of ranking number so the automatic scheduler
can take that into account

when a human assigns tasks, these are things they undoubtably think about...

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
have an awesome day
*