Insert record, send email to email address not on form?

Hi, I have a DA created page which collects client information and assign it to a staff member which has been selected from a dynamic drop down. Is there any way I can get UE to email this staff member with the record details?

For example, from the staff member menu list, I select 'John Smith', this stores his ContactID in the table. I need UE to then email John Smith with the insert record details but his email address isnt available in session.

It does exist in the recordset ie; Name: John Smith, ContactID: 100, Email: js@sky.com so inside UE I selected that field from a recordset but its doesnt work, probably as it doesnt know which email I need? <?php echo $row_WADADynListtblAdvisor['ContactEmail']; ?>

Any ideas how I would grab the email address for the inserted record?

Thanks

When the insert behaviour is used, it creates the new unique ID in a session.

You can then use this session to filter a new recordset to select the new record.

Then use the details from the recordset to populate your UE fields.

Essentially you are on the right path, but you need to load the information into a recordset.

There are other ways around it of course, in that you could store the POST value of the email field in a session and use that. So your POST behaviour would trigger:

i) Store the POST value of the email field in a session
ii) Insert the record using the WA Insert Behaviour
iii) Use the session that stores the email address as the to address in UE.

It all depends which route you want to go down.

Personally, I would go with the creation of the recordset filtered by the new unique ID created by the insert behaviour.

Cheers
Ian

Hi Ian, many thanks for your kind help. Would I be correct in doing this;

Create new recordset including ContactEmail & CaseID, filter the CaseID against the session of the insert behaviour which is tblcases_CaseID2. Then in UE choose that recordset.field as the email address?

Can t try it out on my demo machine as doesnt send mail, will try and do on live now to test!

thanks again

Gary

Ok, just tried on live, I must have messed something up....again! In my recordset I have WHERE tblcases.CaseID = "tblcases_CaseID2", now when I load my page I get the following error:
Parse error: syntax error, unexpected T_STRING in D:\Domains\ghldomain.co.uk\wwwroot\4\tblcases_Insert.php on line 135

Line 135 is:

$query_rsFilter4Email = "SELECT tblcases.ContactAssignedTo, tblcontacts.ContactEmail, tblcases.CaseID FROM tblcontacts Inner Join tblcases On tblcases.ContactAssignedTo = tblcontacts.ContactID WHERE tblcases.CaseID = "tblcases_CaseID2" ORDER BY tblcases.CaseID Desc ";

I replaced the "" with '' on where clause which allows page to load but no email is sent, I also change where clause to WHERE tblcases.CaseID = $_SESSION['tblcases_CaseID2'], but that also produces page error of : Parse error: syntax error, unexpected T_VARIABLE in C:\wamp\www\filter4.php on line 35

Am I writing the Where incorrectly?

Hi,

You are mixing mySQL syntax and PHP by the looks of it. Ideally you should be using parameters rather than inline PHP values however, your syntax should look something like this:

$query_rsFilter4Email = "SELECT tblcases.ContactAssignedTo, tblcontacts.ContactEmail, tblcases.CaseID FROM tblcontacts Inner Join tblcases On tblcases.ContactAssignedTo = tblcontacts.ContactID WHERE tblcases.CaseID = ".$_SESSION['tblcases_CaseID2']." ORDER BY tblcases.CaseID Desc ";

This is assuming that the session you are creating within the WA Insert behaviour is called tblcases_CaseID2.

This recordset also needs to come after the Insert behaviour so that the Session Variable exists. If you are running this on the same page as the form (i.e posting the form to itself) then you will also want to wrap this new recordset in a trigger such as the one used by the Insert Behaviour so that the recordset is only called when the form is posted.

Hope that makes sense!?

Cheers
Ian

Hi Ian, thanks again, got it now. I created a Param value in the recordset usi ng the session value from the insert behaviour..

WHERE tblcases.CaseID = ParamCaseID

This seems to do the trick, thank you very much for your help..

regards

Gary

:-) You are welcome.

Glad to hear that you got it working.

Cheers
Ian

Arggh, think I may have spoken to soon and its live now! For some reason the email gets sent to the last record entered in db not the current record that's stored in session value?

For example:
case 100 - John Smith
case 101 - Kate Middleton
Case 102 - $_SESSION['tblcases_CaseID2'] this is taken from the insert behaviour

When inputting case 102 it should email the user being entered and filter the case id but it emails case 101 etc?

I have the email as the last part of the process, not sure how the previous case session is being stored? If I drag the session onto the page in testing it does indeed show the caseid I am creating and not the previous, so how is it getting the previous cases email address??

EDIT *** The above is incorrect, the previous case is held in session. If I add a case, then submit I can go to other parts of the site, return to insert cases page and its held the previous records value, is it possible to kill the session value after email? I have page if anyone can help..

Any ideas more than welcome..

Thanks

Sorry, attached now..

**** Edit - Hi, after h=going back and reading your post Ian I moved the code below the insert record code and appears to be ok for now!

Thanks again..