timesheet inserts........

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

1 and 2 are going to take custom script in javascript and/or php to pull off. 3 should just be a matter of using the insert ID that is stored in the session to filter the Recordset and using that to construct the email. I think this one is probably too complex to walk you through in the forums alone.

re 1 and 2 thought that would be the case....will get in touch for a prem

re 3, not sure how to do this....have got timesheet_insert as a session variable in the binding panel just dont know how to us it to achiebve that..

You can use a simple recordset filtered with the session variable value: WADA_Insert_product_contents or whatever you have it set to in the insert server behavior.

as soon as I add a recordset, the page stops sending....havent even set it up to filter

Try updating:

<?php require('../../../webassist/mysqli/rsobj.php'); ?>

to

<?php require_once('../../../webassist/mysqli/rsobj.php'); ?>

thats got it, not sure what the filter should be as what I have set up isnt working:

<?php
$WADAtimesheet_insert = new WA_MySQLi_RS("WADAtimesheet_insert",$DBConnection,1);
$WADAtimesheet_insert->setQuery("SELECT * FROM timesheets WHERE TimesheetID = ?");
$WADAtimesheet_insert->bindParam("i", "".(isset($_SESSION['WADAtimesheet_insert'])?$_SESSION['WADAtimesheet_insert']:"")  ."", "-1"); //colname
$WADAtimesheet_insert->execute();
?>

Your insert page had the session name: "WADA_Insert_product_contents"

Did you update it?

yes I did....

<?php 
// WA DataAssist Insert
if (isset($_POST["Insert"]) || isset($_POST["Insert_x"])) // Trigger
{
  $WA_connection = $PowerCMSConnection;
  $WA_table = "timesheets";
  $WA_sessionName = "WADAtimesheet_insert";
  $WA_redirectURL = "timesheet_results.php";
  if (function_exists("rel2abs")) $WA_redirectURL = $WA_redirectURL?rel2abs($WA_redirectURL,dirname(__FILE__)):"";
  $WA_keepQueryString = false;

It seems like that would work. Is your email code after your insert code?