Using Scheduled Task for email alerts

[bespokeappstt]

I want to create a schedule that sends an email to some@some.com whenever the list has a value for the elements 'due_date_out' and 'due_date_in' and no value for 'actual_date_in'. I am using SMTP in Joomla and that works fine. The elements being checked look like this:

So once the first two have a value and the third has no value, send the email. How do I set this up in Scheduled Task?

 

[troester]

http://fabrikar.com/forums/index.php?wiki/scheduled-tasks/
http://fabrikar.com/forums/index.php?wiki/email-scheduled-task/#php-duration-example

of if you want to do it yourself
http://fabrikar.com/forums/index.php?wiki/php-scheduled-task/

 

[bespokeappstt]

I have set the frequency to 5 seconds and nothing happens.

 

[troester]

Scheduled task system plugin enabled?
Valid email, subject, message?
Any row returning true in condition? (0 is no date format)

You can "run" a scheduled task from the backend manually, including e.g. debug output and exit;

 

[bespokeappstt]

Going to have a look at #__fabrik_logs.

 

[bespokeappstt]

The email part is all good:


and I changed the block:

 

[bespokeappstt]

In phpmyadmin I am seeing the date elements are default to NULL:


In the condition block can I use is_null to check if the date elements are set?

$in = '{rad_rentals___due_date_out}';
$out = '{rad_rentals___due_date_in}';
$actual = '{rad_rentals___actual_date_in}';
if(is_null($in))
{  }
else
{  }

 

[troester]

"Test mode" is for using "Run" in the backend and get some debug output for every row which would send something. So

After assigning a placeholder (= a string which may be empty) a variable is always set.
Use empty() (but this is php, not Fabrik).

 

[bespokeappstt]

Do you have a wiki for using Run? I would like to run and see what the output looks like

 

[troester]

Check the checkbox and click "Run"