Please read the description and expected solution: Reply only with your approach to solution.
I have to allocate multiple tasks to my team on daily basis ( tasks 1-100)
Currently! using excel for allocating the tasks and sending email to each users , doing this repeat activity 2-3 times daily ( time consuming)
Wants to automate via SharePoint 2010 in corporate environment.
Current challenge in SharePoint:
I import the list from excel to SharePoint, But not able to assign multiple tasks : for example- I am able to assign 1 task at a time and send email notification.
Button functionality - Selecting multiple tasks via standard or custom view based on activities and "assigned to users" via custom button and
Parallel workflow - auto fill the selected user from "assigned to" all selected tasks send single notification for all the assigned task.
Once all the tasks are completed, user able to update the status only.(users have limited access to update any field, except status)
To select the type of activity (from the ribbon, even), and then select the user(s) and the multiple tasks for that activity. Then the user can get a single email notification from the activity, or one email for each task assigned. or we can use infopath form. So, the solution can be implemented on any list.
NOTE: I am in corporate environment, so can't play much with server coding, require simple script for button and workflow for email and status.
Please don't assume you can do this until you have strong belief to deliver in a day, only reply and bid for the project.