Vedachalam Mahadevan
02/23/2025, 9:27 AMCeligo AI
02/23/2025, 9:27 AMAI generated answer (using internal Slack threads):To create a select distinct in a saved search in NetSuite, you can use a summary search with a formula numeric. Here's how you can do it: 1. Create a new search or load an existing one. 2. Set the Summary Type to 'Count'. 3. In the formula field, use the DISTINCT function with the field you want to count distinct values for. For example, if you want to count distinct amounts, your formula would be
DISTINCT({amount})
.
This will give you a count of distinct values for the specified field.
In the context of a Suitelet form, you can perform a search and add select options where the record id is the id in the list and the text value is another column from your search. However, please note that you can't load or execute a Saved Search of Saved Searches in SuiteScript.
******
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
02/23/2025, 9:27 AMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.807963312
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.807282209
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.804849446
Celigo AI
02/23/2025, 9:28 AM