ANS-0057 · SAVED SEARCHES & FORMULAS
How to Trigger NetSuite Email Alerts on Field Create or Update?
Configure NetSuite email alerts to fire consistently when a specific field is checked, whether on record creation or subsequent update.
Short answer
To ensure an email alert triggers whenever the 'Export to OpenAir' field is checked, whether on creation or update, remove the 'Updated Fields' trigger from your alert configuration. This creates a catch-all condition for the specified field, ensuring consistent notifications.
Scenario
A NetSuite user requires an email alert to be sent whenever an employee record has the 'Export to OpenAir' field checked. The alert needs to trigger reliably, whether this field is marked during the initial creation of the employee record or as part of a later update.
Solution
To achieve an email alert that triggers when the 'Export to OpenAir' field is checked, irrespective of whether the record is created or updated, the 'Updated Fields' trigger should be entirely removed from the alert's configuration. This adjustment allows the alert to function as a comprehensive trigger for all employees where 'Export to OpenAir' is checked. It is presumed that a criteria filter specifying 'Export to OpenAir' is checked is already established within the alert setup.
Expert NetSuite Support
Need help with this NetSuite issue?
Saved Searches & Formulas consulting and configuration support