for this, what u need to do is, for the field for which when user enters "1", set autoscript "on record save" which'll run a script. This script consists of what so ever u need along with this line :
for this line, u need to specify all the required parameters correctly.
Use it, it'll work.
I'm running Version 11. Pardon my newness, but I do not see a set autoscript "on record save". Where would this be found?
They're called Script Triggers. And in Layout Setup...|Script Triggers, you'll find one called OnRecordCommit.
There is no OnRecord Commit, so I used OnObjectSved. For the script I selected Send Mail and I configured it using parameters that work with a button in another database, so that part of the script works. In the Optional script parameter field I entered Printer Inventory::Qty on hand = Char(1). It worked once but has not worked since. I have 15 records (15 printers that we have) that use the Qty on hand field. When keep track of the qty on hand (so it changes as we take out or add toner for the printer) I want the database to send an email when the any of the toner cartridges inventory drops down to 1.
OnRecordCommit does indeed exist. It's a Layout script trigger and can be found in Layout Setup...|Script triggers.
Char(1) makes no sense here as it returns the character whose ascii code is 1.