My database is mysql. I have a Date field TERMDATE2017 that has a default of NULL. A lot of the values are NULL.
I want to send an email alert to a user if that date changes.
It works when data in the field is changed, but I get a lot of false email alerts when the value is NULL.
In my form
ONLOAD :
sc_set_global({termdate2017}) ;
ONBEFOREUPDATE :
if ([termdate2017] != {termdate2017})
{
(((I compose my email message)))
$mail_message = 'Termination Date Change <br> From : '. [termdate2017] . ’ <br> To : ’ . {termdate2017} . ’ <br> Employee number : ’ . {ee_num} . ’ ';
}
If there is no value in the TERMDATE2017 field, and the user just saves the record, an erroneous alert email is being sent because it considers the global variable BLANK and the new value NULL.
If anyway could help me out, I’d appreciate it.
Thanks.
Termination Date Change
From :
To : null
Employee number : 34