Joe NetSuite
09/10/2024, 4:55 PMCeligo AI
09/10/2024, 4:57 PMAI generated answer (using internal Slack threads):To create a saved search that pulls duplicate value results of a certain field on the form, you can follow these steps: 1. Navigate to the saved search creation page in NetSuite. 2. Select the record type that you want to search for duplicates in. 3. In the Criteria subtab, select the field you want to check for duplicates. 4. In the Results subtab, add the same field and set the Summary Type to 'Group'. 5. Add another field, typically 'Internal ID', and set the Summary Type to 'Count'. 6. In the Summary subtab, add a new filter where 'Count of Internal ID' is greater than 1. This will return a list of values in the selected field that appear more than once in the records. Please note that this will only show the duplicate values, not the individual records that contain these values. To see the individual records, you would need to drill down into the results. Here is an example of how to set up the search: - Criteria: None (or any other criteria you want to apply) - Results: - Field: The field you want to check for duplicates (Summary Type: Group) - Field: Internal ID (Summary Type: Count) - Summary Filter: - Field: Count of Internal ID - Operator: greater than - Value: 1 ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Celigo AI
09/10/2024, 4:57 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.860673189
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.845567703
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.836425662
Celigo AI
09/10/2024, 4:57 PM