Hi Team,
The requirement is to send an email notification when Fieldwork actual start|work_start field value change on Engagement table.
Can anyone help me to understand how Fieldwork actual start|work_start value populates on Engagement(sn_audit_engagement) record and from which script it's auto populating. Thanks in advance.
To send an email notification when the work_start field value changes, you can create a notification:
- Navigate to System Notification > Email > Notifications.
- Click New to create a new notification.
- Set the Table to sn_audit_engagement.
- Set the When to send to Record inserted or updated.
- In the Condition field, add a condition to check if the work_start field has changed:
- Set the Recipients to the appropriate users or groups.
- Write the Subject and Message body for the email.
Answering to your second question, 'Actual Start Date' value of the Engagement auto updates when the first audit task started (i.e. state changes to work in progress in audit task) which denotes that the audit tasks within the engagement is decides the actual start date of the engagement.
