Closed

SharePoint InfoPath TImeSheet

I have create a form in infopath and I need someone to complete the calcucation.

Example:

TimeIn -TimeOut = TImeWorked (9:00 AM - 5:00 PM = 8 hours worked)

I have a field called "PayPeriodStartDate" that user choose from a drop down menu, I need to make sure that in the repeating table that has a field call "PayPeriodDate" that the user is can only choose dates that are in two weeks of the PayPeriodStartDate or they get a validation error.

I have a drop down menu that contains sites, I need for each site to calculate hours worked at a certain site. I have attached the InfoPath form to give you a look at the scope of the work.

Any codeing needs documentation

I have total of 5 list (Staff List, Pay Periods, Time Intervals and Pay Periods)

Pay Periods has a calculated column named StartDate that is populating a drop down list in the infopath named PayPeriodStartDate

The issue that I'm having is that I have I had to use this forumla (=TEXT([Start Date], "mm/dd/yyyy") for the StartDate calcuated column
because I need the date to be in the "mm/dd/yyyy" format.

This means that the data is passed as a string and I run into a problem when I try to enforce a rule on a date field named PayPeriodDate that will make sure the user in within 2 weeks of the PayPeriodStartDate

example:
the user picks 10/1/2011 for a PayPeriodStartDate that means that the date has to be between 10/1/2011 and 10/14/2011 or they will get a vaildation error


The next issue is that I have two drop down time fields called TimeIn and TimeOut and another text box field named hours that will show the results of the time a user worked.

Example:

TimeIn = 9:00 AM TimeOut = 5:00 PM then hours = 8

I can't figure how in infopath to calculate the hours field and I had to manually enter the time in TimeIn and TimeOut and I would rather they get that information from a sharepoint list.


Lastly I have several field at the end that give a subtotal for hours worked at each site and overtime for week 1 and week 2. they have to calculate correctly based on the user input.

I have attached the the infopath form and excel spreadsheets that contain the sharepoint list info

Skills: .NET, C# Programming, Sharepoint, Website Design

See more: infopath timesheet, timesheet infopath sharepoint, infopath timesheet sharepoint, create timesheet infopath, timesheet infopath, sharepoint infopath timesheet, sharepoint create timesheet, sharepoint timesheet, sharepoint website, SharePoint Site, infopath, hours dates, create website sharepoint, sharepoint create website, sharepoint menu, InfoPath form, net infopath, SharePoint work, timeout, timesheet infopath form, sharepoint website design, sharepoint menu design, site sharepoint, menu table design, mobaytech

About the Employer:
( 0 reviews ) Burlington, United States

Project ID: #1244688

10 freelancers are bidding on average $279 for this job

meetesh

Please let me know when we can discuss?

$500 USD in 3 days
(84 Reviews)
8.1
jamalazza

hi I'm ready to begin I'm expert in the field

$450 USD in 3 days
(17 Reviews)
4.8
jatinkindra

Coincidence working over similar application. So can assure of exact results. Hands on experience with various database driven customized managed applications. Experience with various technology domains. Can assure you More

$320 USD in 4 days
(4 Reviews)
3.4
gauravgoyal5

Hi, I am Gaurav Goyal working on SharePoint since last two and half years. I have worked on SharePoint Designer, InfoPath and also I develop web part, web services, forms , workflows in visual studio. I have 8+ ye More

$200 USD in 7 days
(1 Review)
3.1
jakit1989

hi, we understood your [url removed, login to view] see pmb for more detail. thanks, jakit.

$140 USD in 2 days
(0 Reviews)
0.0
jeffnathan

HELLO SIR PLEASE CHECK PMB

$220 USD in 4 days
(0 Reviews)
0.0
sheralistar

i understand your problem please contact me for solution

$220 USD in 10 days
(0 Reviews)
0.0
steve5555

HELLO SIR PLEASE CHECK PMB

$222 USD in 4 days
(0 Reviews)
0.0
gavincg

I'm interested in the project and I can help you with this. Please check PMB for my project proposal. Thanks.

$300 USD in 7 days
(0 Reviews)
0.0
KAbhishekS

I have done the same and can do for this requirement also.

$220 USD in 5 days
(0 Reviews)
0.0