I'm creating a new database for our project managers, and they'd like for any user to be able to modify most fields in the table, but if the "target date" of a project is changed, the project managers should be emailed with information about the record.

It doesn't look like this can be done through field validation, which is what I'd hoped. Does anyone have suggestions for a good way to do this?

At this point, I'm wondering if my only choice is to create a "commit record" button that runs a script to check the field validation, but I fear users may not reliably use such a button, since they have never had to do so before.

~Courtney

You can look into event plugins such as zippscript or EventScript. You should be able to find the links to the websites pretty easily on here. Also if you dont have a mail plugin, look into Mail plugin such as SMTPit or Dacon's Mail.It

Hi,

You can go for creating the calculation fields which will indicate which field is modified and along with the contents that is being modified with new contents. This can be achieved using Get Active Modified Field function...Using that we can code in the script to save that record as PDF and attach it to mail.