Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
NSC | How To Detect Duplicate Values in Fields Using Saved Search
There is a requirement to create a Saved Search that will detect if a Custom Field's value has a duplicate on other record. To do this, kindly follow the steps below:
- In the preferred Saved Search, click Criteria
- Click Summary
- Summary Type: Select Count
- Field: Select Internal ID
- Description: is Greater than 1
- Click Results
- Click Columns
- Field: Select the field that needs a duplicate detection
- Summary Type: Select Group
- Field: Select Internal ID
- Summary Type: Select Count
- Sort By: Select the field in step A
- Click Save
@Kristoffer Viray-Oracle | Ask A Guru | Let us know what contents you like to see in the Community. You can vote here.
Tagged:
0