Search »

Hooks Manager

« Update your View(s)

References »

Introduction

Basic Usage

Examples

References

Step 3: Creating the Hooks Manager rule

Editing "last emailed" rule

Last step is to create a new Hooks Manager rule that ties everything together. What this step does is append some custom PHP that's called whenever an email is sent to a particular submission. Specifically, it updates the new last_emailed field that you just added to the database and keep track of that info.

The code is actually quite simple. You can just copy and paste the following code into the Hooks Manager rule, as shown in the screenshot on this page:

// update the last emailed field for this submission
$table_prefix = "ft_"; // you will need
$now = date("Y-m-d H:i:s");
$query = "UPDATE {$table_prefix}form_{$form_id}
          SET last_emailed = '$now'
          WHERE submission_id = $submission_id";
@mysql_query($query);

The only change you'll need to make is change the $table_prefix variable to store your database prefix (this is found in your /global/config.php file).

Final Notes

The only deficiency of this method is that on the Edit Submission page, the "Email" feature sends the email via Ajax and doesn't instantly update the "Last Edited" field value displayed on the page. It will only be visibly updated when you return to the submission the next time. [Technically, you can solve this by writing a custom template hook... but that's another story!]

DOCUMENTATION

Step 3: Creating the Hooks Manager rule

Final Notes