email Button

Hi,
where do you want to place email button: on the add/edit or list pages?

Hi Jane,
The Edit page is possible.
Many thanks,
Graham

Graham,
one of easiest way to send email is to add some code to the After record updated event on the Events tab. Use Send email with new data action as a sample.

Also you can change button caption to Save and send email on the edit page on the Visual Editor tab.

Hi Jane,
I understand that, but the record will be require to be updated a few times before the email requires to be sent. Won't doing as you suggested email it every time it is updated?
Thanks,
Graham

Graham,
you can do the following:

1. add custom event (Insert PHP code snippet option) on the Edit page on the Visual Editor tab.
   
   Here is a sample:
   

   echo "<INPUT class=button type=button value=&nbsp;&nbsp;send email&nbsp;&nbsp; onclick='window.location=\"TableName_edit.php?editid1=".$_REQUEST["editid1"]."&mail=yes\"'>";
   

2. then add this code to the Edit page: before process event on the Events tab:

if ($_REQUEST["mail"]=="yes")

Thanks, Jane. I tested your codes and it works well.
Still found two problems:

1. The "send email" button is not shown completely. Only "send" appeared.
   
2. probems are that emailing event is in Edit, Before Process, and there are not varibles available at this stage. So I cannot readily use the table field values in my email. A perfect place to have the email event would be Edit, After record updated. But then your codes don't work...
   Any suggestions?

Hi,
try to use this code:

echo "<INPUT class=button type=button value=\"&nbsp;&nbsp;send email&nbsp;&nbsp;\" onclick='window.location=\"TableName_edit.php?editid1=".$_REQUEST["editid1"]."&mail=yes\"'>";

You can select all required values from database in your code:

$str = "select * from TableName where ID=".$_REQUEST["editid1"];