I have set up a timesheet insert, results and update set of pages. (attached)
On the insert page, the user has 7 rows (days) which they can adds when they leave home, when they get on site, when they leave the site and finally when they get home. The user may only add 1 row of data, they may add all 7.
Now, on the insert page I need to do the following:
1. within the drop downs for each day, stop the next drop down from being able to select a time before the one that has been set in the preceeding drop down
2. if the user is adding data to a row, how to stop any of the inputs that are left blank (namely the travel start or travel end) that they are not included as part of the calculation on the results page.
3. cant figure out how to get data from the isert page to be added to the email form that is submitted to the site owner..I know you said to add a RS to the email template, but I couldnt get that to work..
On the results page, I'm not sure why the Travel hours and Total are not showing as 02:00 etc as it is in the On site time: http://prntscr.com/c937dy
Thanks for your help