Netsuite saved search, send email alert only if results count is >4

AI generated answer (using internal Slack threads):

****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** To send an email alert only if the results count of a NetSuite saved search is greater than 4, you can't directly do this within the saved search itself. However, you can achieve this by writing a Scheduled Script in SuiteScript. Here's a high-level overview of how you can do this: 1. Write a Scheduled Script that runs the saved search. 2. In the script, count the number of results from the saved search. 3. If the count is greater than 4, send an email alert. Please note that this approach requires some knowledge of SuiteScript, which is the JavaScript-based API used for customizing NetSuite. Here's a simplified example of how the script might look:

javascript
var search = nlapiLoadSearch(null, 'customsearch_your_saved_search_id');
var resultSet = search.runSearch();
var results = resultSet.getResults(0, 1000); // adjust range as needed

if (results.length > 4) {
    var emailSubject = 'Alert: Saved Search Results Count > 4';
    var emailBody = 'The saved search has returned more than 4 results.';
    nlapiSendEmail(authorId, recipientId, emailSubject, emailBody);
}

In this script, replace

'customsearch_your_saved_search_id'

with the ID of your saved search, and

authorId

and

recipientId

with the appropriate user IDs for the email. Please note that this is a simplified example and may need to be adjusted based on your specific requirements and the complexity of your saved search.