send email trigger based on field value change

we would like to send email alerts to users based on a field value change on the Sales Line table.

This is nav 6.0 classic client, sql db.

can this be done? what would be a good way to do it?

Hi Randy,
Everything (almost) can be done. Whereas this is standard in NAV 9.0 and up, where we have workflow, then it’s something that would require “some” development.
But a good way could be to trigger the code in the OnValidate fo the field you like to check when changed.

This is one of the reasons why you should be on latest versions always.
there are new features available to achieve these kind of requirements.…/

You can send email from onValidate trigger of the field. To compare new and old value of the field you can use xRec.

thank you !!

What Erik says.
You have to add some code to OnValidate trigger of the field i question.