This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

I created a saved search for the email notification whenever a customer’s data is changed. It works, but I am receiving three emails instead of one. Any idea?

When you run the search, how many results do you get?  Any duplicate rows?

If you are using the Chrome Search Export extension (which you should, it’s awesome), can you export the SuiteScript for the search, and post it here so we can see how you are building your search?  Or post screenshots.

image.png

Task seemed to be easy &gt; if someone create new or update existing customer (result field is what we monitor) send an email to the SalesRep

<@U4TPAFXEC> you asked for duplicates? No, one row per customer

Any scripts or WFs running on Customer that might be triggering more updates?

Is there more than one field being changed? It seems like if their was more than one field updated that would cause it

I tested it with changing only phone number.
No other fileds from result list are charged.
Even there is a workflow or an after submit UE script, no impact on the fields from the result list

Unless you specify which fields it should trigger on in the "updated fields" tab, it will trigger on any update on the record. It doesn't care about the columns in the result tab.