Send email script
Hi there :)
I'm wanting to set up a script that checks a field, and if it contains anything greater than 0, I would like to receive an email.... can anyone help?
"checks a field" in what? The current record? Or does it need to perform a find for all records in the field are greater than zero? Or all records where the value is greater than zero and you haven't previously been emailed?
If your script just needs to check the field's value in the current record:
If [YourTable::Field > 0 ]
Send Mail ....
But that seems too simple...
Retrieving data ...