Sharepoint 2007 web part / list calculation
- or -
Post a project like this£1.5k(approx. $1.8k)
- Posted:
- Proposals: 2
- Remote
- #18038
- Expired
Description
Experience Level: Expert
We have a SharePoint list consisting of timecard submissions. Each line contains the staff members payroll number, name, date of shift, hours, hourly rate and department. A custom action/web part is required to:
A) Give manager ability to select each entry inline, eg by a check box on each line in the list view and then a custom action to Approve each selected entry (with approval date and who approved the entry). Only people with a custom permission should be able to approve entries. This permission can then be assigned to supervisors so they can approve entries but not manage the list.
B)A custom action that takes all entries in the list that are marked as approved but not marked as Submitted and then groups by payroll number column and hourly rate column and then totals the hours. A excel spreadsheet is then saved to a document library with the totalled information and all lines that were processed are marked as submitted (including the date they were submitted). The end result should be a line for each member of staff and each hourly rate they have worked at. Another excel spreadsheet is produced totalling the amount paid (hourly rate multiplied by hours) for each department using the same lines as the previous spreadsheet.
C) A web part that is for the user (staff that submits pay entries) to see what entries have been submitted eg last 10 entries, their approval and submission status and date of approval/submission. A simple list part designed to be displayed at the right side of a page.
If you need more details please contact us through the clarification board.
Thanks.
A) Give manager ability to select each entry inline, eg by a check box on each line in the list view and then a custom action to Approve each selected entry (with approval date and who approved the entry). Only people with a custom permission should be able to approve entries. This permission can then be assigned to supervisors so they can approve entries but not manage the list.
B)A custom action that takes all entries in the list that are marked as approved but not marked as Submitted and then groups by payroll number column and hourly rate column and then totals the hours. A excel spreadsheet is then saved to a document library with the totalled information and all lines that were processed are marked as submitted (including the date they were submitted). The end result should be a line for each member of staff and each hourly rate they have worked at. Another excel spreadsheet is produced totalling the amount paid (hourly rate multiplied by hours) for each department using the same lines as the previous spreadsheet.
C) A web part that is for the user (staff that submits pay entries) to see what entries have been submitted eg last 10 entries, their approval and submission status and date of approval/submission. A simple list part designed to be displayed at the right side of a page.
If you need more details please contact us through the clarification board.
Thanks.
Alan R.
100% (1)Projects Completed
8
Freelancers worked with
7
Projects awarded
8%
Last project
1 Oct 2013
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies